Postgres Pro
Downloads
Home   >   mailing lists

Re: plain inserts and deletes very slow - Mailing list pgsql-performance

From Steinar H. Gunderson
Subject Re: plain inserts and deletes very slow
Date
Msg-id 20050703235424.GA16122@uio.no
Whole thread Raw
In response to plain inserts and deletes very slow  (Enrico Weigelt <weigelt@metux.de>)
Responses Re: plain inserts and deletes very slow  (Enrico Weigelt <weigelt@metux.de>)
List pgsql-performance
Tree view 
On Mon, Jul 04, 2005 at 12:45:37AM +0200, Enrico Weigelt wrote:
> my application reads and writes some table quite often
> (multiple times per second). these tables are quite small
> (not more than 20 tuples), but the operations take quite a
> long time (>300 ms!).

Are you VACUUMing often enough?

/* Steinar */
--
Homepage: http://www.sesse.net/

pgsql-performance by date:

Previous
From: Enrico Weigelt
Date:
Subject: plain inserts and deletes very slow
Next
From: Enrico Weigelt
Date:
Subject: Re: plain inserts and deletes very slow