From: Greg Stark <gsstark@mit.edu>
To: matt@followers.net
Cc: pgsql-performance@postgresql.org
Subject: Re: How to improve db performance with $7K?
Date: 14 Apr 2005 13:55:10 -0400
Message-ID: <87is2pgs5d.fsf@stark.xeocode.com> (raw)
In-Reply-To: <425e9283.0422c9db.394e.ffffb643@mx.gmail.com>
References: <425e9283.0422c9db.394e.ffffb643@mx.gmail.com>
"Matthew Nuzum" <matt.followers@gmail.com> writes:
> drive A has capacity C and spins at 15K rpms, and
> drive B has capacity 2 x C and spins at 10K rpms and
> all other features are the same, the price is the same and C is enough
> disk space which would you choose?
In this case you always choose the 15k RPM drive, at least for Postgres.
The 15kRPM reduces the latency which improves performance when fsyncing
transaction commits.
The real question is whether you choose the single 15kRPM drive or additional
drives at 10kRPM... Additional spindles would give a much bigger bandwidth
improvement but questionable latency improvement.
> Would the increased data density of the higher capacity drive be of
> greater benefit than the faster spindle speed of drive A?
actually a 2xC capacity drive probably just has twice as many platters which
means it would perform identically to the C capacity drive. If it has denser
platters that might improve performance slightly.
--
greg
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: gsstark@mit.edu, matt@followers.net
Subject: Re: How to improve db performance with $7K?
In-Reply-To: <87is2pgs5d.fsf@stark.xeocode.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