Re: plain inserts and deletes very slow

From: "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>
To: postgresql performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: plain inserts and deletes very slow
Date: 2005-07-03 23:54:24
Message-ID: 20050703235424.GA16122@uio.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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/

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Enrico Weigelt 2005-07-04 00:01:57 Re: plain inserts and deletes very slow
Previous Message Enrico Weigelt 2005-07-03 22:57:59 Re: plain inserts and deletes very slow