DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type:content-transfer-encoding;
	b=UeEwoAFraNPtcA0aBL3I/QDhpChzctu/TwZUhOJrSgQxNk+oYUzc6fHz1fArOkXrxD
	HfBVCARwLHnnf0d3gIpVx0Yfh0o1x72C30BxUQpDLtTPgMGgy+t7ALGv3FR93ZDljMZe
	OVfIR/yWx9olv5gN/kCvFVKSH8/hr7dQ69EDo=
MIME-Version: 1.0
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>
Date: Tue, 23 Mar 2010 14:10:03 -0600
Message-ID: <dcc563d11003231310p5d110679n2e0cd0d3e61e08f3@mail.gmail.com>
Subject: Re: mysql to postgresql, performance questions
From: Scott Marlowe <scott.marlowe@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: "Ross J. Reedstrom" <reedstrm@rice.edu>, pgsql-performance@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On Tue, Mar 23, 2010 at 1:22 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "Ross J. Reedstrom" <reedstrm@rice.edu> writes:
>> On Sat, Mar 20, 2010 at 10:47:30PM -0500, Andy Colson wrote:
>>> (I added the "and trust" as an after thought, because I do have one ver=
y
>>> important 100% uptime required mysql database that is running. =A0Its m=
y
>>> MythTV box at home, and I have to ask permission from my GF before I ta=
ke
>>> the box down to upgrade anything. =A0And heaven forbid if it crashes or
>>> anything. =A0So I do have experience with care and feeding of mysql. =
=A0And no,
>>> I'm not kidding.)
>
>> 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?

Or SQLite.  I'm guessing that most loads on it are single threaded.