Re: tuning questions - Mailing list pgsql-performance

From scott.marlowe
Subject Re: tuning questions
Date
Msg-id Pine.LNX.4.33.0312041111470.17542-100000@css120.ihs.com
Whole thread Raw
In response to Re: tuning questions  (Josh Berkus <josh@agliodbs.com>)
List pgsql-performance
On Thu, 4 Dec 2003, Josh Berkus wrote:

> Scott,
>
> > Just to add to what the others have said here, you probably want to run
> > the pg_autovacuum daemon in the background.  It comes with 7.4 but will
> > work fine with 7.3.
>
> I don't recommend using pg_autovacuum with a data transformation task.   pg_av
> is designed for "regular use" not huge batch tasks.

What bad thing is likely to happen if it's used here?  Fire too often or
use too much I/O bandwidth?  Would that be fixed by the patch being tested
to introduce a delay every x pages of vacuuming?


pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: tuning questions
Next
From: Gaetano Mendola
Date:
Subject: Re: autovacuum daemon stops doing work after about an hour