Re: Optimizer improvements: to do or not to do?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Optimizer improvements: to do or not to do?
Дата
Msg-id 17246.1158183513@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Optimizer improvements: to do or not to do?  (Ron Mayer <rm_pg@cheapcomplexdevices.com>)
Список pgsql-hackers
Ron Mayer <rm_pg@cheapcomplexdevices.com> writes:
> I'm wildly guessing that, the # of pages itself seems to be
> a bigger factor than the sequential/random nature.

No, they're both important: fetching N pages in sequence is way cheaper
than fetching the same number of pages scattered all over.  This is
partly because you reduce seeking at the hardware level, and partly
because sequential reads cue the kernel to do read-ahead, allowing
overlap of I/O and computation.
        regards, tom lane


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

Предыдущее
От: Ron Mayer
Дата:
Сообщение: Re: Optimizer improvements: to do or not to do?
Следующее
От: "Marshall, Steve"
Дата:
Сообщение: Re: - Proposal for repreparing prepared statements