Partitioning an existing table - Mailing list pgsql-general

From Phoenix Kiula
Subject Partitioning an existing table
Date
Msg-id BANLkTi=_aeBhkmxLBfRf9y-S-mVdeUSDKA@mail.gmail.com
Whole thread Raw
Responses Re: Partitioning an existing table
Re: Partitioning an existing table
Re: Partitioning an existing table
List 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

pgsql-general by date:

Previous
From: Linos
Date:
Subject: 10 missing features
Next
From: Cédric Villemain
Date:
Subject: Re: Partitioning an existing table