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

From Tom Lane
Subject Re: new GUC var: autovacuum_process_all_tables
Date
Msg-id 17309.1234201037@sss.pgh.pa.us
Whole thread Raw
In response to Re: new GUC var: autovacuum_process_all_tables  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Josh Berkus wrote:
>> 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?

Like, say, pg_reload_conf()?  But actually a cron job would almost
certainly find it more pleasant to use pg_ctl reload and never bother
with a database connection at all.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: I can see beta now
Next
From: Marko Kreen
Date:
Subject: Re: WIP: fix SET WITHOUT OIDS, add SET WITH OIDS