Re: tuning questions

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.