Re: dell versus hp - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: dell versus hp
Date
Msg-id dcc563d10711081524t7543cdfbk86fad7d099b0b7d1@mail.gmail.com
Whole thread Raw
In response to Re: dell versus hp  (Alan Hodgson <ahodgson@simkin.ca>)
Responses Re: dell versus hp
List pgsql-performance
On Nov 8, 2007 2:56 PM, Alan Hodgson <ahodgson@simkin.ca> wrote:
> On Thursday 08 November 2007, Dimitri Fontaine <dfontaine@hi-media.com>
> > Is raid6 better than raid10 in term of overall performances, or a better
> > cut when you need capacity more than throughput?
>
> You can't touch RAID 10 for performance or reliability. The only reason to
> use RAID 5 or RAID 6 is to get more capacity out of the same drives.

Actually, RAID6 is about the same on reliability, since it has double
parity and theoretically ANY TWO disks could fail, and RAID6 will
still have all your data.  If the right two disks fail in a RAID-10
you lose everything.  Admittedly, that's a pretty remote possibility,
but so it three drives failing at once in a RAID-6.

For performance RAID-10 is still pretty much the best choice.

pgsql-performance by date:

Previous
From: Gregory Stark
Date:
Subject: Re: Estimation problem with a LIKE clause containing a /
Next
From: Tom Lane
Date:
Subject: Re: Join performance