Re: [GENERAL] partitioning a table containing millions of records

2008-10-27 Thread Andreas Jochem
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 wan

Re: [GENERAL] partitioning a table containing millions of records

2008-10-25 Thread Nikolas Everett
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

[GENERAL] partitioning a table containing millions of records

2008-10-25 Thread Andreas Jochem
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 o