Josh Berkus wrote:
> I can't imagine, nor have I encountered in the 3 years of consulting I
> did since Autovaccum became available, such a use case.
Ok, so due to popular demand, I'm not implementing this new GUC.
> On the other hand, I'd been keen on a runtime suset autovaccum=on/off
> which we could call from a cron job or the pgadmin scheduler in order to
> have maintenance windows. Unless that's already becoming possible?
autovacuum=on/off is already SIGHUP as of 8.3 (not SUSET, since it makes
no sense to change it in a single connection).
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support