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 по дате отправления: