Re: In the belly of the beast (MySQLCon)

From: "Dawid Kuroczko" <qnex42(at)gmail(dot)com>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>, Geoffrey <lists(at)serioustechnology(dot)com>, "Alan Hodgson" <ahodgson(at)simkin(dot)ca>, pgsql-general(at)postgresql(dot)org
Subject: Re: In the belly of the beast (MySQLCon)
Date: 2008-04-20 21:56:15
Message-ID: 758d5e7f0804201456h372a463t5e8cf97d0c594cf2@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-general

On Fri, Apr 18, 2008 at 9:04 PM, Joshua D. Drake <jd(at)commandprompt(dot)com> wrote:
> On Fri, 18 Apr 2008 14:59:34 -0400
> Alvaro Herrera <alvherre(at)commandprompt(dot)com> wrote:
>
> > I find it pretty unlikely that Slony would be unable to help you
> > upgrade here. Obviously you can upgrade one database at a time.
> >
> > Also, mostly it's not the database size what's a concern, but rather
> > the size of the largest table.
>
> As I recall (I could be wrong) Slony syncs the whole set as a single
> transaction. So if he has his entire database as a set he may
> have a problem regardless of the largest or smallest table. I would also
> agree that 30 million rows is likely not a problem but he should still
> check his velocity.

Well, you can sync one table at a time (create a (temporary) set with
one able, subscribe it, SYNC, MERGE SET, rince, lather, repeat). :)

Regards,
Dawid

In response to

Browse pgsql-advocacy by date

  From Date Subject
Next Message laser 2008-04-21 05:59:12 Re: [pgsql-www] Can somebody add a link on wiki.postgresql.org
Previous Message Scott Marlowe 2008-04-20 18:55:02 Re: In the belly of the beast (MySQLCon)

Browse pgsql-general by date

  From Date Subject
Next Message christian_behrens 2008-04-20 22:19:34 Need to update all my 60 million rows at once without transactional integrity
Previous Message BLazeD 2008-04-20 19:53:42 Re: Changed Hosts, Lots of Errors in PostgreSQL - Help Please!