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
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