On Thu, May 27, 2010 at 9:01 AM, venu madhav <venutaurus539@xxxxxxxxx> wrote: > Thanks for the reply.. > I am using postgres 8.01 and since it runs on a client box, I > can't upgrade it. I've set the auto vacuum nap time to 3600 seconds. You've pretty much made autovac run every 5 hours with that setting. What was wrong with the original settings? Just wondering what problem you were / are trying to solve here. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance