Re: Scaling further up

Поиск
Список
Период
Сортировка
От Paul Thomas
Тема Re: Scaling further up
Дата
Msg-id 20040303085718.A24535@bacon
обсуждение исходный текст
Ответ на Re: Scaling further up  (johnnnnnn <john@phaedrusdeinus.org>)
Ответы Re: Scaling further up
Список pgsql-performance
On 02/03/2004 23:25 johnnnnnn wrote:
> [snip]
> random_page_cost should be set with the following things taken into
> account:
>   - seek speed

Which is not exactly the same thing as spindle speed as it's a combination
of spindle speed and track-to-track speed. I think you'll find that a 15K
rpm disk, whilst it will probably have a lower seek time than a 10K rpm
disk, won't have a proportionately (i.e., 2/3rds) lower seek time.

>   - likelihood of page to be cached in memory by the kernel

That's effective cache size.


--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants         |
http://www.thomas-micro-systems-ltd.co.uk   |
+------------------------------+---------------------------------------------+

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