Table inheritance and partitioning

From: Kevin Barnard <kevin(dot)barnard(at)laser2mail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Table inheritance and partitioning
Date: 2009-05-27 20:52:52
Message-ID: 0E1961A9-C617-4F8F-B6AE-77E5EF91FC99@laser2mail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am making the move to partition a table. I am trying to figure out
the best way to migrate data to the partitions. I would prefer to not
have down time. Does anybody have advice to give on this? Is there
any easy way to determine what records are in the master table and
which ones are in child tables? I can think of a few migration ideas
doing this.

Thanks in advance.

--
Kevin Barnard
kevin(dot)barnard(at)laser2mail(dot)com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Bailey 2009-05-27 20:55:23 Re: composite type and domain
Previous Message Grzegorz Jaśkiewicz 2009-05-27 20:45:57 Re: composite type and domain