On Thu, 4 Dec 2003, Jack Coates wrote:
> Another problem is that performance of the 6 million row job is decent
> if I stop the job and run a vacuumdb --analyze before letting it
> continue; is this something that 7.4 will help with? vacuumb --analyze
> doesn't seem to have much effect on the 18 million row job.
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.