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?
