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

From: Pavan Deolasee <pavan(dot)deolasee(at)gmail(dot)com>
To: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Vlad Bailescu <vlad(at)mojitosoftware(dot)com>
Subject: Re: Turning auto-analyze off (was Re: [GENERAL] Unusually high IO for autovacuum worker)
Date: 2013-02-01 16:16:38
Message-ID: CABOikdOCm3tJDCkgcfX_enxNXRa1e56250sikhb6atCVcOgF_w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Feb 1, 2013 at 9:07 PM, Alvaro Herrera <alvherre(at)2ndquadrant(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2013-02-01 16:19:26 Re: PATCH: Split stats file per database WAS: autovacuum stress-testing our system
Previous Message Andrew Dunstan 2013-02-01 16:06:34 Re: obsolete code