Re: Auto ANALYZE criteria

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Joe Miller <joe.d.miller@xxxxxxxxx> 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

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux