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

Re: mysql to postgresql, performance questions

From: Hannu Krosing <hannu(at)2ndquadrant(dot)com>
To: Yeb Havinga <yebhavinga(at)gmail(dot)com>
Cc: Greg Smith <greg(at)2ndquadrant(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "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-24 08:59:58
Message-ID: 1269421198.11473.50.camel@hvost (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
On Wed, 2010-03-24 at 09:55 +0100, 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  (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).

Pulling the plug should not corrupt a postgreSQL database, unless it was
using disks which lie about write caching.

Now need for WAL replica for that

> regards,
> Yeb Havinga

Hannu Krosing
PostgreSQL Scalability and Availability 
   Services, Consulting and Training

In response to


pgsql-performance by date

Next:From: Greg SmithDate: 2010-03-24 12:09:50
Subject: Re: mysql to postgresql, performance questions
Previous:From: Yeb HavingaDate: 2010-03-24 08:57:15
Subject: Re: mysql to postgresql, performance questions

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