Re: [GENERAL] Very slow moving between partition

2011-02-07 Thread Vincent Veyron
Le lundi 07 février 2011 à 02:42 -0600, Mario Medina a écrit : > That works good with small number of records, but if I have 300,000 > records it can take a lot of time to move that records. > well, that's a lot of records to move. I would guess you are I/O bound with your present disks, and fas

[GENERAL] Very slow moving between partition

2011-02-07 Thread Mario Medina
Hi! I have a big table with about 26 millon registers, and I have 3 partitions, one that handles daily information, only one register per day for about 24,000 elements, that's it about 24,000 register daily, other one that handles one register per minute per day, only 8 hours a day, for about 9000