Re: ANALYZE sampling is too good

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: ANALYZE sampling is too good
Дата
Msg-id 30686.1386633155@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: ANALYZE sampling is too good  (Heikki Linnakangas <hlinnakangas@vmware.com>)
Список pgsql-hackers
Heikki Linnakangas <hlinnakangas@vmware.com> writes:
> Maybe. Or maybe the heuristic read ahead isn't significant/helpful, when you're prefetching with posix_fadvise
anyway.

Yeah.  If we're not reading consecutive blocks, readahead is unlikely
to do anything anyhow.

Claudio's comments do suggest that it might be a bad idea to issue a
posix_fadvise when the next block to be examined *is* adjacent to the
current one, though.
        regards, tom lane



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

Предыдущее
От: Claudio Freire
Дата:
Сообщение: Re: ANALYZE sampling is too good
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [RFC] Shouldn't we remove annoying FATAL messages from server log?