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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
