Skip site navigation (1) Skip section navigation (2)

Re: vacuuming and manu updates

From: "Daniel T(dot) Staal" <DStaal(at)usa(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: vacuuming and manu updates
Date: 2005-10-26 13:34:51
Message-ID: 54569.63.172.115.138.1130333691.squirrel@MageHandbook.com (view raw or flat)
Thread:
Lists: pgsql-novice
On Wed, October 26, 2005 7:12 am, kadil said:
> Hi,
>
> I have a small table (100 rows) and I update its values every 8 seconds.
> This leads to poor performance until I vacuum. pg8.0 on w2000. Any
> suggestions on how often to vacuum or would I be better off doing delete
> and inserts for improved sustainable performance

How long before the performance degradation in unacceptable?

Vacuuming just that table shouldn't be much of a problem, so I'd say
vacuum as often as necessary to keep performance within parameters.  ;)

Daniel T. Staal

---------------------------------------------------------------
This email copyright the author.  Unless otherwise noted, you
are expressly allowed to retransmit, quote, or otherwise use
the contents for non-commercial purposes.  This copyright will
expire 5 years after the author's death, or in 30 years,
whichever is longer, unless such a period is in excess of
local copyright law.
---------------------------------------------------------------


In response to

Responses

pgsql-novice by date

Next:From: Ted RolleDate: 2005-10-26 15:19:43
Subject: psql goes away in a flash
Previous:From: Oliver ElphickDate: 2005-10-26 13:18:40
Subject: Re: First Install

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group