Re: Auto ANALYZE criteria - Mailing list pgsql-performance

From Tom Lane
Subject Re: Auto ANALYZE criteria
Date
Msg-id 8963.1285101860@sss.pgh.pa.us
Whole thread Raw
In response to Re: Auto ANALYZE criteria  (Joe Miller <joe.d.miller@gmail.com>)
Responses Re: Auto ANALYZE criteria
List pgsql-performance
Joe Miller <joe.d.miller@gmail.com> writes:
> I was looking at the autovacuum documentation:
> http://www.postgresql.org/docs/9.0/interactive/routine-vacuuming.html#AUTOVACUUM

>    For analyze, a similar condition is used: the threshold, defined as:
>    analyze threshold = analyze base threshold + analyze scale factor *
> number of tuples
>    is compared to the total number of tuples inserted or updated since
> the last ANALYZE.

> I guess that should be updated to read "insert, updated or deleted".

Mph.  We caught the other places where the docs explain what the analyze
threshold is, but missed that one.  Fixed, thanks for pointing it out.

            regards, tom lane

pgsql-performance by date:

Previous
From: "Ozer, Pam"
Date:
Subject: Re: Using Between
Next
From: Tom Lane
Date:
Subject: Re: Query much faster with enable_seqscan=0