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

On Tue, Feb  5, 2013 at 01:41:05PM +0530, Pavan Deolasee wrote:
> On Fri, Feb 1, 2013 at 10:53 PM, Bruce Momjian  wrote:
> >
> >
> > Are these TODO items?
> >
> 
> BTW, there are couple of TODOs.
> 
> 1. Analyze should be done  based on the total row churn across the
> parent + children.  Looking at the parent only, as we do now, can
> result in analyzing too often or too seldom.
> 
> 2. Auto-analyze should analyze parent and each child table in a
> separate transaction.

I added a link to this thread on the TODO list under:
Improve autovacuum tuning 

--  Bruce Momjian          http://momjian.us EnterpriseDB                             http://enterprisedb.com
 + It's impossible for everything to be true. +