Josh Berkus wrote:
>>> 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.
Hmm, I'm not sure I understand what you're suggesting. Maybe what you
want is that we have a SQL-accesible function that sends SIGHUP to the
postmaster?