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