Re: Auto ANALYZE criteria

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Auto ANALYZE criteria
Дата
Msg-id 8963.1285101860@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Auto ANALYZE criteria  (Joe Miller <joe.d.miller@gmail.com>)
Ответы Re: Auto ANALYZE criteria
Список 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 по дате отправления:

Предыдущее
От: "Ozer, Pam"
Дата:
Сообщение: Re: Using Between
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Query much faster with enable_seqscan=0