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

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.

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

Sincerely,

Joshua D. Drake

--
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate