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

Re: vacuuming and manu updates

From: <operationsengineer1(at)yahoo(dot)com>
To: "Daniel T(dot) Staal" <DStaal(at)usa(dot)net>, pgsql-novice(at)postgresql(dot)org
Subject: Re: vacuuming and manu updates
Date: 2005-10-26 15:57:17
Message-ID: 20051026155717.2825.qmail@web33304.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
--- "Daniel T. Staal" <DStaal(at)usa(dot)net> wrote:

> 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

is there a way to automate the vacuum process on
windows (think cron on linux)?


		
__________________________________ 
Yahoo! FareChase: Search multiple travel sites in one click.
http://farechase.yahoo.com

In response to

Responses

pgsql-novice by date

Next:From: A. KretschmerDate: 2005-10-26 16:18:01
Subject: Re: Where is #pgsql
Previous:From: Ted RolleDate: 2005-10-26 15:45:32
Subject: Where is #pgsql

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