Re: Experience with HP Smart Array P400 and SATA drives? - Mailing list pgsql-performance

From Mario Weilguni
Subject Re: Experience with HP Smart Array P400 and SATA drives?
Date
Msg-id 493FE8B2.9040809@sime.com
Whole thread Raw
In response to Re: Experience with HP Smart Array P400 and SATA drives?  (Aidan Van Dyk <aidan@highrise.ca>)
Responses Re: Experience with HP Smart Array P400 and SATA drives?
List pgsql-performance
Aidan Van Dyk schrieb:
> * Mario Weilguni <mweilguni@sime.com> [081210 07:31]:
>
>
>> Why not? I know it's not performing as good as RAID-10, but it does not
>> waste 50% diskspace. RAID-6 is no option, because the performance is
>> even worse. And, on another system with RAID-5 + spare and SAS drives,
>> the same controller is working very well.
>>
>
> Like Scott said, it's all about trade-offs.
>
> With raid5, you get abysmal write performance, "make me not sleep at
> night" inconsistent parity issues, and a degraded mode that will a
> nightmare  ...
>
> ... and as a trade-off you save a little money, and get good "read only"
> performance ...
>
> ... as long as you don't ever have a disk or system crash ...
>
> ... or can afford to rebuild if you do ...
>
> ... etc ...
>

In fact, for this system we're currently going to RAID10, I'm convinced
now. With other systems we have, RAID5 is a safe option for one reason,
the machines are clusters, so we have (sort of) RAID50 here:
Machine A/RAID5 <-- DRBD --> Machine B/RAID5

Seems reliable enough for me. But in this case, the machine will be
standalone, and so RAID5 might really not be the best choice.


However, I'm pretty sure we'll have the same problems with RAID10, the
problem seems  to have to do with P400 and/or SATA drives.


pgsql-performance by date:

Previous
From: Aidan Van Dyk
Date:
Subject: Re: Experience with HP Smart Array P400 and SATA drives?
Next
From: "Scott Marlowe"
Date:
Subject: Re: Experience with HP Smart Array P400 and SATA drives?