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=mY267bX5w4AeLVjUnv3NX3rVzoJP7+JMAfHgbP5LH49vrZa3mPscZzbWaBojGxvwjj
	CRZDQTnKK6S6EdFtRIvPhie/7jIVGSabf7Ya0uI3S48NljWw1wE72uREHungDuo7jjfU
	VszAzJFdpfvKYKNc+5ImwChibNPbWyygaanbk=
Message-ID: <4BA9D3EB.30403@gmail.com>
Date: Wed, 24 Mar 2010 09:57:15 +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> <4BA9D39B.6020103@gmail.com>
In-Reply-To: <4BA9D39B.6020103@gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Yeb Havinga wrote:
> 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  
forgot to add "how to fix the corrupted tables", sorry
> (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