Postgres Pro
Downloads
Home   >   mailing lists

Re: Turning auto-analyze off (was Re: [GENERAL] Unusually high IO for autovacuum worker) - Mailing list pgsql-hackers

From Pavan Deolasee
Subject Re: Turning auto-analyze off (was Re: [GENERAL] Unusually high IO for autovacuum worker)
Date
Msg-id CABOikdOCm3tJDCkgcfX_enxNXRa1e56250sikhb6atCVcOgF_w@mail.gmail.com
Whole thread Raw
In response to Re: Turning auto-analyze off (was Re: [GENERAL] Unusually high IO for autovacuum worker)  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
Tree view 
On Fri, Feb 1, 2013 at 9:07 PM, Alvaro Herrera <alvherre@2ndquadrant.com> wrote:
> Pavan Deolasee escribió:
>
>>
>> A new reloption such as autovacuum_analyze_enabled is what we need.
>
> I was thinking in this option just three days ago, so yeah.
>
> I think we also want an option to turn off just vacuum.
>

+1. I think that will be useful too in some situations, especially
when user wants to let autovacuum take care of some tables  and
manually vacuum the rest.

Thanks,
Pavan

--
Pavan Deolasee
http://www.linkedin.com/in/pavandeolasee

pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: obsolete code
Next
From: Alvaro Herrera
Date:
Subject: Re: PATCH: Split stats file per database WAS: autovacuum stress-testing our system