To: Scott Marlowe <scott.marlowe@gmail.com>
cc: Dave Crooke <dcrooke@gmail.com>, Greg Smith <greg@2ndquadrant.com>,
	"Ross J. Reedstrom" <reedstrm@rice.edu>, pgsql-performance@postgresql.org
Subject: Re: mysql to postgresql, performance questions 
In-reply-to: <dcc563d11003231630o61ac2c76qccea3256bb3354d0@mail.gmail.com> 
References: <4BA23936.2030507@gmail.com> <4BA596D2.4050406@squeakycode.net>
	<20100323185232.GD6662@rice.edu> <5342.1269372121@sss.pgh.pa.us>
	<4BA934B9.9070401@2ndquadrant.com>
	<ca24673e1003231607k11138834qb9a5d4283b06c047@mail.gmail.com>
	<dcc563d11003231630o61ac2c76qccea3256bb3354d0@mail.gmail.com>
Comments: In-reply-to Scott Marlowe <scott.marlowe@gmail.com>
	message dated "Tue, 23 Mar 2010 17:30:48 -0600"
Date: Tue, 23 Mar 2010 19:35:33 -0400
Message-ID: <10261.1269387333@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>

Scott Marlowe <scott.marlowe@gmail.com> writes:
> On Tue, Mar 23, 2010 at 5:07 PM, Dave Crooke <dcrooke@gmail.com> wrote:
>> What about InnoDB?

> Depends on what parts of mysql they otherwise use.  There are plenty
> of features that won't work if you're using non-myisam tables, like
> full text search.  I tend to think any full blown (or nearly so) db is
> overkill for mythtv, and the use of something like sqllite or berkely
> db tables is a better fit.

That's apparently also the position of their lead developer; although
considering he's not actually done anything about it for six or more
years, it seems like quite a lame excuse for blocking ports to other
DBs.

			regards, tom lane