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?


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to