From: Ron Mayer <rm_pg@cheapcomplexdevices.com>
To: William Yu <wyu@talisys.com>
Subject: Re: Hardware/OS recommendations for large databases (
Date: Wed, 16 Nov 2005 13:08:58 -0800
Message-ID: <437B9FEA.5010003@cheapcomplexdevices.com> (raw)
In-Reply-To: <dlfjuk$9n9$1@news.hub.org>
References: <3E37B936B592014B978C4415F90D662D01995F7B@MI8NYCMAIL06.Mi8.com>
<33c6269f0511152115v1a34ab81j30f1f5df5a6c6956@mail.gmail.com>
<437B3B18.1040509@commandprompt.com>
<437B4773.1040404@boreham.org>
<dlfjuk$9n9$1@news.hub.org>
William Yu wrote:
>
> Our SCSI drives have failed maybe a little less than our IDE drives.
Microsoft in their database showcase terraserver project has
had the same experience. They studied multiple configurations
including a SCSI/SAN solution as well as a cluster of SATA boxes.
They measured a
6.4% average annual failure rate of their SATA version and a
5.5% average annual failure rate on their SCSI implementation.
ftp://ftp.research.microsoft.com/pub/tr/TR-2004-107.pdf
"We lost 9 drives out of 140 SATA drives on the Web and
Storage Bricks in one year. This is a 6.4% annual failure rate.
In contrast, the Compaq Storageworks SAN and Web servers lost
approximately 32 drives in three years out of a total of 194
drives.13 This is a 5.5% annual failure rate.
The failure rates indicate that SCSI drives are more
reliable than SATA. SATA drives are substantially
cheaper than SCSI drives. Because the SATA failure rate
is so close to the SCSI failure rate gives SATA a
substantial return on investment advantage."
So unless your system is extremely sensitive to single drive
failures, the difference is pretty small. And for the cost
it seems you can buy enough extra spindles of SATA drives to
easily make up for the performance difference.
> Basically, I've found it's cooling that's most important. Packing the
> drives together into really small rackmounts? Good for your density, not
> good for the drives.
Indeed that was their guess for their better-than-expected
life of their SATA drives as well. From the same paper:
"We were careful about disk cooling – SATA
drives are rarely cooled with the same care that a SCSI
array receives."
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: rm_pg@cheapcomplexdevices.com, wyu@talisys.com
Subject: Re: Hardware/OS recommendations for large databases (
In-Reply-To: <437B9FEA.5010003@cheapcomplexdevices.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