Postgres Pro
Downloads
Home   >   mailing lists

Re: slow insert query. - Mailing list pgsql-general

From Richard Huxton
Subject Re: slow insert query.
Date
Msg-id 434E7368.8070205@archonet.com
Whole thread Raw
In response to slow insert query.  (julien WICQUART <j.wicquart@newtech.fr>)
List pgsql-general
Tree view 
julien WICQUART wrote:
>
> But we still have insert that take more that 1s on little table (24000 tupples with 10 rows).
>
> We've got 633 connexions/mn on our all databases (68 databases with less than 10 rows each) which

How often are you vacuuming?

What does "VACUUM FULL VERBOSE little_table" show for
removable/non-removable row versions?

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: "Bill Bartlett"
Date:
Subject: Re: Limitations of PostgreSQL
Next
From: "John D. Burger"
Date:
Subject: Re: Text->Date conversion in a WHERE clause