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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | A. Kretschmer | 2005-10-26 16:18:01 | Re: Where is #pgsql |
Previous Message | Ted Rolle | 2005-10-26 15:45:32 | Where is #pgsql |