Re: AutoVacuum on demand? - Mailing list pgsql-general

From Matthew T. O'Connor
Subject Re: AutoVacuum on demand?
Date
Msg-id 4559D60E.20607@zeut.net
Whole thread Raw
In response to Re: AutoVacuum on demand?  (Csaba Nagy <nagy@ecircle-ag.com>)
Responses Re: AutoVacuum on demand?  (Csaba Nagy <nagy@ecircle-ag.com>)
List pgsql-general
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?


pgsql-general by date:

Previous
From: "surabhi.ahuja"
Date:
Subject: libpq.so full name?
Next
From: Martijn van Oosterhout
Date:
Subject: Re: libpq.so full name?