From: | Andreas Jochem <andruit(at)gmx(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: partitioning a table containing millions of records |
Date: | 2008-10-27 09:43:47 |
Message-ID: | 49058D53.9080407@gmx.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas | 2008-10-27 09:47:13 | Re: a LEFT JOIN problem |
Previous Message | wstrzalka | 2008-10-27 08:59:42 | psql screen size |