Re: How is random_page_cost=4 ok?

Поиск
Список
Период
Сортировка
От Ron Mayer
Тема Re: How is random_page_cost=4 ok?
Дата
Msg-id 48EFCAAB.7020702@cheapcomplexdevices.com
обсуждение исходный текст
Ответ на Re: How is random_page_cost=4 ok?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane wrote:
> In particular, if the OS lays out successive file pages in a way that
> provides zero latency between logically adjacent blocks, I'd bet a good
> bit that a Postgres seqscan would miss the read timing every time, and
> degrade to handling about one block per disk rotation.

Unless the OS does some readahead when it sees something like a seq scan?



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: How is random_page_cost=4 ok?
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: How is random_page_cost=4 ok?