On Wed, Jun 25, 2008 at 9:03 AM, Matthew Wakeling <[EMAIL PROTECTED]> wrote:
> On Wed, 25 Jun 2008, Merlin Moncure wrote:
>>>
>>> Has anyone done some benchmarks between hardware RAID vs Linux MD
>>> software
>>> RAID?
>>
>> I have here:
>>
>> http://merlinmoncure.blogspot.com/2007/08/following-are-results-of-our-testing-of.html
>>
>> The upshot is I don't really see a difference in performance.
>
> The main difference is that you can get hardware RAID with battery-backed-up
> cache, which means small writes will be much quicker than software RAID.
> Postgres does a lot of small writes under some use cases.
As discussed down thread, software raid still gets benefits of
write-back caching on the raid controller...but there are a couple of
things I'd like to add. First, if your sever is extremely busy, the
write back cache will eventually get overrun and performance will
eventually degrade to more typical ('write through') performance.
Secondly, many hardware raid controllers have really nasty behavior in
this scenario. Linux software raid has decent degradation in overload
conditions but many popular raid controllers (dell perc/lsi logic sas
for example) become unpredictable and very bursty in sustained high
load conditions.
As greg mentioned, I trust the linux kernel software raid much more
than the black box hw controllers. Also, contrary to vast popular
mythology, the 'overhead' of sw raid in most cases is zero except in
very particular conditions.
merlin
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
