Skip site navigation (1) Skip section navigation (2)

Re: mysql to postgresql, performance questions

From: Greg Smith <greg(at)2ndquadrant(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu>, pgsql-performance(at)postgresql(dot)org
Subject: Re: mysql to postgresql, performance questions
Date: 2010-03-23 21:38:01
Message-ID: 4BA934B9.9070401@2ndquadrant.com (view raw or flat)
Thread:
Lists: pgsql-performance
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(at)2ndQuadrant(dot)com   www.2ndQuadrant.us


In response to

Responses

pgsql-performance by date

Next:From: Ross J. ReedstromDate: 2010-03-23 21:39:42
Subject: Re: mysql to postgresql, performance questions
Previous:From: Szu-Ching PecknerDate: 2010-03-23 21:37:56
Subject: Re: tuning auto vacuum for highly active tables

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group