DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:user-agent:mime-version:to:cc:subject
	:references:in-reply-to:content-type:content-transfer-encoding;
	b=LRtEqFVTIS0uZX+D49fcQzWrCkeIAnVC8Ww3Q3cnx0JKLXjQZ9+gHaeQ/I0nunVhPf
	bySAfGP6rvoRtANdxgTi90n7soMTV2l/5aGHWXzxmwET5w6tplryy/xfrmdHczxVOt0B
	mH3/oGz2h2s8fa9oV+poTjJsUq9TJeiPxQ0xo=
Message-ID: <4BA9D39B.6020103@gmail.com>
Date: Wed, 24 Mar 2010 09:55:55 +0100
From: Yeb Havinga <yebhavinga@gmail.com>
User-Agent: Thunderbird 2.0.0.24 (Windows/20100228)
MIME-Version: 1.0
To: Greg Smith <greg@2ndquadrant.com>
CC: Tom Lane <tgl@sss.pgh.pa.us>, "Ross J. Reedstrom" <reedstrm@rice.edu>,
	pgsql-performance@postgresql.org
Subject: Re: mysql to postgresql, performance questions
References: <4BA23936.2030507@gmail.com> <4BA596D2.4050406@squeakycode.net>
	<20100323185232.GD6662@rice.edu> <5342.1269372121@sss.pgh.pa.us>
	<4BA934B9.9070401@2ndquadrant.com>
In-Reply-To: <4BA934B9.9070401@2ndquadrant.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Greg Smith wrote:
> 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.
It would be the same with PG, unless the pg cluster configuration with 
mythtv would come with a properly configured WAL - I had corrupted 
tables (and a personal wiki entry  (the other mysql database in my 
house) *only* when I sometimes took the risk of not shutting down the 
machine properly when e.g. the remote was missing).

regards,
Yeb Havinga