From: Paul Thomas <paul@tmsl.demon.co.uk>
To: pgsql-performance @ postgresql . org <pgsql-performance@postgresql.org>
Subject: Re: Scaling further up
Date: Wed, 3 Mar 2004 08:57:18 +0000
Message-ID: <20040303085718.A24535@bacon> (raw)
In-Reply-To: <20040302232540.GA4102@performics.com>
References: <4BAFBB6B9CC46F41B2AD7D9F4BBAF785098039@vt-pe2550-001.vantage.vantage.com>
<Pine.LNX.4.33.0403021411570.4475-100000@css120.ihs.com>
<20040302232540.GA4102@performics.com>
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 |
+------------------------------+---------------------------------------------+
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: paul@tmsl.demon.co.uk
Subject: Re: Scaling further up
In-Reply-To: <20040303085718.A24535@bacon>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox