--- "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
> 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.
In response to
pgsql-novice by date
|Next:||From: A. Kretschmer||Date: 2005-10-26 16:18:01|
|Subject: Re: Where is #pgsql|
|Previous:||From: Ted Rolle||Date: 2005-10-26 15:45:32|
|Subject: Where is #pgsql|