pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Josh Berkus <josh@agliodbs.com>
To: johnnnnnn <john@phaedrusdeinus.org>
To: scott.marlowe <scott.marlowe@ihs.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Scaling further up
Date: Wed, 3 Mar 2004 11:09:23 -0800
Message-ID: <200403031109.23201.josh@agliodbs.com> (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>

John,

> This would imply that an upgrade in drive RPM should be accompanied by
> a decrease in random_page_cost, correct?

Maybe.  Maybe not.   Tom's Hardware did some Bonnie++ testing with a variety 
of new drives last year.   They were moderately surprised to find that there 
were "faster" drives (i.e. higher RPM) which had lower real throughput due to 
poor onboard software and hardware, such as a small and slow onboard cache.

So, it would be reasonable to assume that a 10,000 RPM Barracuda could support 
marginally lower random_page_cost than a 7,200 RPM Barracuda ... but that 
tells you nothing about a 10,000 RPM Maxtor Diamond (as an example).

Also, many other factors influence real random_page_cost; the size and access 
pattern of your database is probably much more important than your RPM.

-- 
-Josh Berkus
 Aglio Database Solutions
 San Francisco




view thread (35+ messages)  latest in thread

Message-ID: <200403031109.23201.josh@agliodbs.com>
Permalink:  ../200403031109.23201.josh@agliodbs.com/
Also on:    postgresql.org/message-id/200403031109.23201.josh@agliodbs.com

 · 

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: josh@agliodbs.com, john@phaedrusdeinus.org, scott.marlowe@ihs.com
  Subject: Re: Scaling further up
  In-Reply-To: <200403031109.23201.josh@agliodbs.com>

* 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