Re: new GUC var: autovacuum_process_all_tables - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: new GUC var: autovacuum_process_all_tables
Date
Msg-id 498CC111.4040801@agliodbs.com
Whole thread Raw
In response to Re: new GUC var: autovacuum_process_all_tables  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: new GUC var: autovacuum_process_all_tables
List pgsql-hackers
Alvaro,

>> 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).

Right.  What I'm saying is that if it *didn't* require a sighup, then 
users could cronjob starting and stopping Autovac themselves.

--Josh



pgsql-hackers by date:

Previous
From: Euler Taveira de Oliveira
Date:
Subject: Re: autovacuum and reloptions
Next
From: Stephen Frost
Date:
Subject: Re: Column-Level Privileges