Re: vacuuming and manu updates

--- "Daniel T. Staal" <DStaal@usa.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