Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 5280A632817 for ; Tue, 23 Mar 2010 18:39:55 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 96378-05 for ; Tue, 23 Mar 2010 21:39:44 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from cooker.cnx.rice.edu (cooker.cnx.rice.edu [168.7.5.70]) by mail.postgresql.org (Postfix) with ESMTP id E51ED63271B for ; Tue, 23 Mar 2010 18:39:44 -0300 (ADT) Received: from reedstrm by cooker.cnx.rice.edu with local (Exim 4.63) (envelope-from ) id 1NuBp8-00042i-VX; Tue, 23 Mar 2010 16:39:42 -0500 Date: Tue, 23 Mar 2010 16:39:42 -0500 From: "Ross J. Reedstrom" To: Tom Lane Cc: pgsql-performance@postgresql.org Subject: Re: mysql to postgresql, performance questions Message-ID: <20100323213942.GE6662@rice.edu> Mail-Followup-To: "Ross J. Reedstrom" , Tom Lane , pgsql-performance@postgresql.org References: <4BA23936.2030507@gmail.com> <4BA596D2.4050406@squeakycode.net> <20100323185232.GD6662@rice.edu> <5342.1269372121@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <5342.1269372121@sss.pgh.pa.us> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201003/297 X-Sequence-Number: 38122 On Tue, Mar 23, 2010 at 03:22:01PM -0400, Tom Lane wrote: > "Ross J. Reedstrom" writes: > > > Andy, you are so me! I have the exact same one-and-only-one mission > > critical mysql DB, but the gatekeeper is my wife. And experience with > > that instance has made me love and trust PostgreSQL even more. > > So has anyone looked at porting MythTV to PG? > My understanding from perusing mailing list archives is that there have been multiple attempts to provide a database neutral layer and support different backend databases (mostly w/ PG as the driver) but the lead developer has been something between disintrested and actively hostile to the idea. I think this page http://www.mythtv.org/wiki/PostgreSQL_Support say it all: deleted "PostgreSQL Support" (Outdated, messy and unsupported) And the Wayback machine version: http://web.archive.org/web/20080521003224/http://mythtv.org/wiki/index.php/PostgreSQL_Support Ross -- Ross Reedstrom, Ph.D. reedstrm@rice.edu Systems Engineer & Admin, Research Scientist phone: 713-348-6166 The Connexions Project http://cnx.org fax: 713-348-3665 Rice University MS-375, Houston, TX 77005 GPG Key fingerprint = F023 82C8 9B0E 2CC6 0D8E F888 D3AE 810E 88F0 BEDE