Re: controlling autovacuum during the day.

On Wed, Dec 17, 2008 at 7:17 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "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.

is it a bad idea to have such a feature ?
i was going through ./src/backend/postmaster/autovacuum.c
looks like  subroutine autovac_start can be modfied to
for the said feature. In case it does not have negative implication
can i submit a patch ?

regds
-- mallah.


>
>                        regards, tom lane
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>