Csaba Nagy wrote:
> [snip]
>
>> I think the idea is to edit the postgresql.conf file on the fly and send
>> a SIGHUP to the postmaster. I haven't ever heard of anyone doing that,
>> but I don't see any reason why it wouldn't work.
>>
>
> It works, I did it for a while with the statement_timeout to change it
> globally over night when admin tasks were running. For the
> statement_timeout thing it wasn't optimal however, finally I had to
> ditch the thing... but it can be done.
I'm confused, what does statement timeout have to do with this? I was
assuming you would edit "autovacuum = off" to "autovacuum = on" wouldn't
that work?