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