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 faster ones are needed.
Some study material here :
http://wiki.postgresql.org/wiki/Performance_Optimization
--
Vincent Veyron
http://marica.fr/
Logiciel de gestion des dossiers de contentieux et d'assurance pour le service juridique