Re: Database-wide VACUUM ANALYZE - Mailing list pgsql-performance

From Steven Flatt
Subject Re: Database-wide VACUUM ANALYZE
Date
Msg-id 357fa7590706211337i55e9b20nea5a1bd4c5e41268@mail.gmail.com
Whole thread Raw
In response to Re: Database-wide VACUUM ANALYZE  (Bill Moran <wmoran@collaborativefusion.com>)
Responses Re: Database-wide VACUUM ANALYZE  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: Database-wide VACUUM ANALYZE  (Jim Nasby <decibel@decibel.org>)
List pgsql-performance
Thanks everyone.  It appears that we had hacked the 502.pgsql script for our 8.1 build to disable the daily vacuum.  I was not aware of this when building and upgrading to 8.2.
 
So it looks like for the past two weeks, that 36 hour db-wide vacuum has been running every 24 hours.  Good for it for being reasonably non-intrusive and going unnoticed until now. :)
 
Although apparently not related anymore, I still think it was a good move to change autovacuum_freeze_max_age from 200 million to 2 billion.
 
Steve
 

pgsql-performance by date:

Previous
From: "Steven Flatt"
Date:
Subject: Re: Very long SQL strings
Next
From: Tom Lane
Date:
Subject: Re: Very long SQL strings