Re: How is random_page_cost=4 ok?

Поиск
Список
Период
Сортировка
От Gregory Stark
Тема Re: How is random_page_cost=4 ok?
Дата
Msg-id 87vdw01s1g.fsf@oxford.xeocode.com
обсуждение исходный текст
Ответ на Re: How is random_page_cost=4 ok?  (Gregory Stark <stark@enterprisedb.com>)
Список pgsql-hackers
Gregory Stark <stark@enterprisedb.com> writes:

>> For "Server Drives" 3-4ms are more realistic ([2], [3]) for average seeks and
>> the 110-170MB/sec are highly exaggerated.
>
> In that case both of those numbers come straight from Seagate's data sheet for
> their top-of-the-line data centre drives:
>
> http://www.seagate.com/docs/pdf/datasheet/disc/ds_cheetah_15k_6.pdf

Oh, but I just noticed they separately quote latency and read/write seek time.
The average read seek time is 3.4ms. That gives a random_page_cost of 45-71.

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com Ask me about EnterpriseDB's PostGIS support!


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: CLUSTER, REINDEX, VACUUM in "read only" transaction?
Следующее
От: Kenneth Marshall
Дата:
Сообщение: Re: CLUSTER, REINDEX, VACUUM in "read only" transaction?