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

On Fri, Feb 1, 2013 at 10:53 PM, Bruce Momjian <bruce@momjian.us> 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.

Thanks,
Pavan

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