Re: Very slow moving between partition - Mailing list pgsql-general

From Vincent Veyron
Subject Re: Very slow moving between partition
Date
Msg-id 1297110623.2924.6.camel@asus-1001PX.home
Whole thread Raw
In response to Very slow moving between partition  (Mario Medina <osoverflow@gmail.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Edoardo Panfili
Date:
Subject: Re: postgis 1.5.2 installation configure: WARNING: could not locate CUnit required for liblwgeom unit tests
Next
From: "Joshua D. Drake"
Date:
Subject: PgEast: 2011, CFP closes in three days