Skip site navigation (1) Skip section navigation (2)

Re: Consumer-grade vs enterprise-grade disk drives

From: "Jeffrey W(dot) Baker" <jwbaker(at)acm(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Consumer-grade vs enterprise-grade disk drives
Date: 2005-05-31 18:27:04
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
On Mon, 2005-05-30 at 21:38 -0700, Luke Lonergan wrote:
> Tom,
> This is a story that is evolving.  Anyone else use StorageReview?  Great
> comprehensive drive benchmarks:
> Check the comparisons between 15K RPM SCSI drives and the 2004 Western
> Digital 10K RPM SATA (Raptor) drives.  The Raptors are an interesting hybrid
> of SCSI-related tech and desktop tech, and were some of the first drives
> with SCSI-like command queuing TCQ/NCQ.

If we're looking at the same benchmark (File Server DriveMark), the
fastest SCSI disk is 65% faster than the fastest SATA disk.  The fastest
SCSI 10K disk is 25% faster than the SATA.

> I think the last remaining issue in moving to SATA for all enterprise use is
> the lack of decent SATA controllers, though 3Ware ( is
> getting there:

The 3Ware controllers are probably the worst ones you can get for
database use.  Their caches are slow (I didn't even know that was
possible until I bought one), as are the XOR engines.

After reading this very comprehensive benchmark:

I purchased one of the Areca controllers with a large battery-backed
cache.  It is unholy fast.  I recommend it.


In response to


pgsql-hackers by date

Next:From: Tom LaneDate: 2005-05-31 18:49:09
Subject: Re: CREATE DATABASE fails when template1 being accessed ...
Previous:From: Manfred KoizarDate: 2005-05-31 17:58:35
Subject: Re: Cost of XLogInsert CRC calculations

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group