Re: controlling autovacuum during the day.

On Wed, Dec 17, 2008 at 7:17 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "John Lister" <john(dot)lister-ps(at)kickstone(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>