Re: Thoughts on statistics for continuously advancing columns

Поиск
Список
Период
Сортировка
Искать
От
Craig Ringer
Тема
Re: Thoughts on statistics for continuously advancing columns
Дата
Msg-id
4B3C262F.4080205@postnewspapers.com.au
Ответ на
Список
Дерево обсуждения
Re: Thoughts on statistics for continuously advancing columns Chris Browne <cbbrowne@acm.org>
Re: Thoughts on statistics for continuously advancing columns Tom Lane <tgl@sss.pgh.pa.us>

> While regular ANALYZE seems to be pretty good ... is it insane to
> suggest determining the min/max bounds of problem columns by looking at
> a btree index on the column in ANALYZE, instead of relying on random
> data sampling? An ANALYZE that didn't even have to scan the indexes but
> just look at the ends might be something that could be run much more
> frequently with less I/O and memory cost than a normal ANALYZE, just to
> selectively update key stats that are an issue for such continuously
> advancing columns.

... which Tom Lane already raised in a smarter way in a message I hadn't 
read yet. Sorry for the noise.

--
Craig Ringer

В списке pgsql-hackers по дате отправления
От: Craig Ringer
Дата:
От: Tatsuo Ishii
Дата:
Сообщение: Re: exec_execute_message crash
FAQ