Thread: partitioning a table containing millions of records

Hi,
I have a question concerning the topic patitioning.

I have a table with millions of records and I would like to partition
it. I have already read the documentation but it could not answer my
question.

My question is, the following:
Do I have to create the master and child tables and so  on before
inserting the data or is it also possible to partition a table which
already contains millions of records??? And how can I do this??? Has
anybody done this before???

Thanks.

Andi

There is no fast way to split an existing table into partitions.  Create a new parent table, create partitions, create the insert trigger, and then INSERT INTO newparent SELECT * FROM unpartitioned.  You may want to split that into groups if you have many millions of rows.

Thanks for your reply,

I gonna try your suggestion.

Andi


Nikolas Everett wrote:
> There is no fast way to split an existing table into partitions.
> Create a new parent table, create partitions, create the insert
> trigger, and then INSERT INTO newparent SELECT * FROM unpartitioned.
> You may want to split that into groups if you have many millions of rows.
>
>
> On Sat, Oct 25, 2008 at 6:47 AM, Andreas Jochem <andruit@gmx.de
> <mailto:andruit@gmx.de>> wrote:
>
>     Hi,
>     I have a question concerning the topic patitioning.
>
>     I have a table with millions of records and I would like to
>     partition it. I have already read the documentation but it could
>     not answer my question.
>
>     My question is, the following:
>     Do I have to create the master and child tables and so  on before
>     inserting the data or is it also possible to partition a table
>     which already contains millions of records??? And how can I do
>     this??? Has anybody done this before???
>
>     Thanks.
>
>     Andi
>
>
>
>     --
>     Sent via pgsql-general mailing list (pgsql-general@postgresql.org
>     <mailto:pgsql-general@postgresql.org>)
>     To make changes to your subscription:
>     http://www.postgresql.org/mailpref/pgsql-general
>
>