From: Greg Smith <greg@2ndquadrant.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Ross J. Reedstrom <reedstrm@rice.edu>
Cc: pgsql-performance@postgresql.org
Subject: Re: mysql to postgresql, performance questions
Date: Tue, 23 Mar 2010 17:38:01 -0400
Message-ID: <4BA934B9.9070401@2ndquadrant.com> (raw)
In-Reply-To: <5342.1269372121@sss.pgh.pa.us>
References: <4BA23936.2030507@gmail.com>
<4BA596D2.4050406@squeakycode.net>
<20100323185232.GD6662@rice.edu>
<5342.1269372121@sss.pgh.pa.us>
Tom Lane wrote:
> So has anyone looked at porting MythTV to PG?
>
Periodically someone hacks together something that works, last big
effort I'm aware of was in 2006, and then it bit rots away. I'm sure
we'd get some user uptake on the result--MySQL corruption is one of the
top ten cause of a MythTV system crashing. The developers are so
resistant to database-neutral design that you'd need quite the thick
skin to try and get something into their mainline though, which means
someone who tried adding PostgreSQL support would likely have to run a
parallel branch for some time, expecting regular breakage. The only
thing on their radar as far as I know is SQLite.
There was a good overview circa 2004 at
http://david.hardeman.nu/files/patches/mythtv/mythletter.txt , haven't
done a deep dive into the code recently enough to comment on exactly
what has changed since then. That gives a flavor for the fundamentals
of the design issues though.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com www.2ndQuadrant.us
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: greg@2ndquadrant.com, tgl@sss.pgh.pa.us, reedstrm@rice.edu
Subject: Re: mysql to postgresql, performance questions
In-Reply-To: <4BA934B9.9070401@2ndquadrant.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox