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

Re: Experience with HP Smart Array P400 and SATA drives?

From: Mario Weilguni <mweilguni(at)sime(dot)com>
To: Aidan Van Dyk <aidan(at)highrise(dot)ca>
Cc: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Experience with HP Smart Array P400 and SATA drives?
Date: 2008-12-10 16:05:06
Message-ID: 493FE8B2.9040809@sime.com (view raw or flat)
Thread:
Lists: pgsql-performance
Aidan Van Dyk schrieb:
> * Mario Weilguni <mweilguni(at)sime(dot)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.


In response to

Responses

pgsql-performance by date

Next:From: Scott MarloweDate: 2008-12-10 16:17:28
Subject: Re: Experience with HP Smart Array P400 and SATA drives?
Previous:From: Aidan Van DykDate: 2008-12-10 15:52:08
Subject: Re: Experience with HP Smart Array P400 and SATA drives?

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