Re: slow insert query.

From: Richard Huxton <dev(at)archonet(dot)com>
To: julien WICQUART <j(dot)wicquart(at)newtech(dot)fr>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: slow insert query.
Date: 2005-10-13 14:47:04
Message-ID: 434E7368.8070205@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John D. Burger 2005-10-13 14:52:16 Re: Text->Date conversion in a WHERE clause
Previous Message Tom Lane 2005-10-13 14:06:20 Re: How to inject knowledge into a Postgres database