Re: Partitioned Tables - How/Can does slony handle it?

From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Partitioned Tables - How/Can does slony handle it?
Date: 2008-08-28 15:54:54
Message-ID: 200808280854.55135@hal.medialogik.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thursday 28 August 2008, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
> Ow Mun Heng wrote:
> > I posed this question to the Slony List as well, but no response yet.
>
> It's actually in the Slony docs:
> http://www.slony.info/documentation/partitioning.html
>
> I haven't actually used it in production myself, though :-)

It works (at least add_empty_table_to_replication() does). It's certainly
not automatic, but it's a lot easier than creating a new set, replicating
it and merging it every time you add partitions.

--
Alan

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2008-08-28 16:04:36 Re: Vaccuum best practice: cronjob or autovaccuum?
Previous Message Alvaro Herrera 2008-08-28 15:48:00 Re: Vaccuum best practice: cronjob or autovaccuum?