Re: Very slow moving between partition

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