pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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   |
+------------------------------+---------------------------------------------+



view thread (35+ messages)  latest in thread

Message-ID: <20040303085718.A24535@bacon>
Permalink:  ../20040303085718.A24535@bacon/
Also on:    postgresql.org/message-id/20040303085718.A24535@bacon

 · 

reply

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