From: | Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk> |
---|---|
To: | "pgsql-performance (at) postgresql (dot) org" <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Scaling further up |
Date: | 2004-03-03 08:57:18 |
Message-ID: | 20040303085718.A24535@bacon |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 |
+------------------------------+---------------------------------------------+
From | Date | Subject | |
---|---|---|---|
Next Message | Florian Weimer | 2004-03-03 09:25:28 | Bulk INSERT performance in 7.4.1 |
Previous Message | Rod Taylor | 2004-03-03 02:28:00 | Re: Scaling further up |