Re: controlling autovacuum during the day. - Mailing list pgsql-admin

From Tom Lane
Subject Re: controlling autovacuum during the day.
Date
Msg-id 27759.1229521625@sss.pgh.pa.us
Whole thread Raw
In response to Re: controlling autovacuum during the day.  ("John Lister" <john.lister-ps@kickstone.com>)
Responses Re: controlling autovacuum during the day.  (Rajesh Kumar Mallah <mallah.rajesh@gmail.com>)
List pgsql-admin
"John Lister" <john.lister-ps@kickstone.com> writes:
> I'd like to use autovacuum to clean up the tables rather than schedule a
> full vacuum with cron as it will be more selective/intelligent about what
> gets cleaned. But is it possible to stop it running during peak/office
> hours?

No.  Instead, set the vacuum cost parameters to make it run slow enough
to not interfere too much with your work.

            regards, tom lane

pgsql-admin by date:

Previous
From: "John Lister"
Date:
Subject: Re: controlling autovacuum during the day.
Next
From: "John Lister"
Date:
Subject: Re: controlling autovacuum during the day.