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? -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers