Partitioning an existing table

From: Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com>
To: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Partitioning an existing table
Date: 2011-04-25 10:46:23
Message-ID: BANLkTi=_aeBhkmxLBfRf9y-S-mVdeUSDKA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi.

The partitioning documentation in PG is very clear on how to partition
a new table. Create child tables, and have triggers that manage
INSERT, UPDATE and DELETE commands.

How about doing this with existing massive tables? (Over 120 million rows)

I could create a new parent table with child tables, and then INSERT
all these millions of rows to put them into the right partition. But
is that recommended?

Thanks

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Cédric Villemain 2011-04-25 10:57:56 Re: Partitioning an existing table
Previous Message Linos 2011-04-25 08:41:36 10 missing features