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

Re: Joshua Drake's "What MySQL Can Learn FromPostgreSQL" talk at MySQL Con 2008

From: Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: Selena Deckelmann <selenamarie(at)gmail(dot)com>, PostgreSQL Advocacy List <pgsql-advocacy(at)postgresql(dot)org>
Subject: Re: Joshua Drake's "What MySQL Can Learn FromPostgreSQL" talk at MySQL Con 2008
Date: 2008-04-18 18:30:58
Message-ID: 1208543458.2731.71.camel@bnicholson-desktop (view raw or flat)
Thread:
Lists: pgsql-advocacy
On Fri, 2008-04-18 at 11:13 -0700, Joshua D. Drake wrote:
> On Fri, 18 Apr 2008 14:03:53 -0400
> Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info> wrote:
> 
> > On Fri, 2008-04-18 at 10:38 -0700, Selena Deckelmann wrote:
> > > JD's talk and slides:
> > > http://www.commandprompt.com/blogs/joshua_drake/2008/04/what_mysql_and_really_sun_can_learn_from_postgresql/
> > > 
> > > Review of the talk:
> > > http://www.bytebot.net/blog/archives/2008/04/17/what-mysql-can-learn-from-postgresql
> > > 
> > 
> > Interesting reads.
> > 
> > I have to agree with the part about lack of in place upgrades.  I
> > would have say that that is the single biggest thorn in our PG using
> > side here at Afilias.  Upgrading the data layer via Slony is a
> > **massive** undertaking.
> 
> The problem is not that it is inappropriate. It is that it doesn't work
> for databases of that size. Even at 500GB you can have serious issues
> with Slony.

Agreed. We're living with the pain of this with one particular support
system. We have ways to upgrade it that don't involve Slony, but it's
even more painful than the Slony upgrade process.

> This is not actually a Slony limitation but a PostgreSQL one. 

Agreed.  Slony does a great job of this where it is technically
feasible.  It just a really big pain, and takes a lot of work if your
databases are anything but trivial in size.

In place upgrades is number 1 on my wish list.

Brad.


In response to

Responses

pgsql-advocacy by date

Next:From: Joshua D. DrakeDate: 2008-04-18 18:43:17
Subject: Re: In the belly of the beast (MySQLCon)
Previous:From: GeoffreyDate: 2008-04-18 18:30:18
Subject: Re: In the belly of the beast (MySQLCon)

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