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

From Enrico Weigelt
Subject Re: plain inserts and deletes very slow
Date
Msg-id 20050703225759.GC9777@nibiru.borg.metux.de
Whole thread Raw
In response to Re: plain inserts and deletes very slow  ("Steinar H. Gunderson" <sgunderson@bigfoot.com>)
List pgsql-performance
* Steinar H. Gunderson <sgunderson@bigfoot.com> wrote:
> 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?

I've just VACUUM'ed multiple times, so it's perhaps not the problem.


cu
--
---------------------------------------------------------------------
 Enrico Weigelt    ==   metux IT service
  phone:     +49 36207 519931         www:       http://www.metux.de/
  fax:       +49 36207 519932         email:     contact@metux.de
---------------------------------------------------------------------
  Realtime Forex/Stock Exchange trading powered by postgresSQL :))
                                            http://www.fxignal.net/
---------------------------------------------------------------------

pgsql-performance by date:

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