Partitioned Tables - How/Can does slony handle it?

From: Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com>
To: pgsql <pgsql-general(at)postgresql(dot)org>
Subject: Partitioned Tables - How/Can does slony handle it?
Date: 2008-08-28 07:20:19
Message-ID: 1219908019.6034.32.camel@neuromancer.home.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I posed this question to the Slony List as well, but no response yet.

I'll post it here as well, to elicit some responses, as there's a larger
community of people using PG+Slony who may also be on slony-list.

The question that I have is, I'm trying to determine if there's a
possibility that I can do table partitioning and still use slony to
replicate the table to the slave.

1st. I'm not sure if it can be done, if it can, then how does it do it?
Is it able to automatically add the new partitioned table or will it
need to be manually added through slonik?

If anyone has any experience in this, it would be good for my knowledge
as I'm trying to optimise the DB I have. The individual tables are close
to like 60million rows and occupying ~15G (+15G Indexes)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Phoenix Kiula 2008-08-28 07:23:39 Slow PG after upgrade to 8.2.9!!
Previous Message Scott Marlowe 2008-08-28 07:11:05 Re: Restoring a database from a file system snapshot