Re: partitioning a table containing millions of records

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(at)gmx(dot)de
> <mailto:andruit(at)gmx(dot)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(at)postgresql(dot)org
> <mailto:pgsql-general(at)postgresql(dot)org>)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
>