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
Дата: