Re: correct behavior of ANALYZE ...

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: correct behavior of ANALYZE ...
Дата
Msg-id 5730.1188405879@sss.pgh.pa.us
обсуждение исходный текст
Ответ на correct behavior of ANALYZE ...  (Hans-Juergen Schoenig <postgres@cybertec.at>)
Ответы Re: correct behavior of ANALYZE ...  (Hans-Juergen Schoenig <postgres@cybertec.at>)
Список pgsql-hackers
Hans-Juergen Schoenig <postgres@cybertec.at> writes:
> i came across some interesting behavior of pg_stats and i am not sure
> if this is something we should treat the way we do it.

Setting target zero means "expend no work on this column".  In my book
that includes not doing anything to any pre-existing pg_stats entry.
What you propose would defeat the ability to analyze an unchanging
column once and then make ANALYZE skip over it henceforth.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Hans-Juergen Schoenig
Дата:
Сообщение: correct behavior of ANALYZE ...
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Contrib modules documentation online