From: | Rajesh Kumar Mallah <mallah(dot)rajesh(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | John Lister <john(dot)lister-ps(at)kickstone(dot)com>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: controlling autovacuum during the day. |
Date: | 2009-02-11 15:37:07 |
Message-ID: | a97c77030902110737v1321d2d5va32daee833a0ad50@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | John Lister | 2009-02-11 16:31:55 | Re: controlling autovacuum during the day. |
Previous Message | Carol Walter | 2009-02-11 15:11:14 | Re: User defined functions... - Found to be tsearch |