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

Re: Advice on RAID card

From: "Luke Lonergan" <LLonergan(at)greenplum(dot)com>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>,"PFC" <lists(at)boutiquenumerique(dot)com>
Cc: "Dave Cramer" <pg(at)fastcrypt(dot)com>,"Michael Ben-Nes" <miki(at)canaan(dot)co(dot)il>,pgsql-performance(at)postgresql(dot)org
Subject: Re: Advice on RAID card
Date: 2005-09-25 18:09:30
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
>>     Even for RAID5 ? it uses a bit more CPU for the parity calculations.

> I honestly can't speak to RAID 5. I don't (and won't) use it. RAID 5 is 
> a little brutal when under
> heavy write load. I use either 1, or 10.

Yes, for RAID5 software RAID is better than HW RAID today - the modern general purpose CPUs are *much* faster at the ECC calculations than the CPUs on most modern hardware SCSI RAID cards.

Note that there is a trend toward SATA RAID, and the newer crop of SATA RAID adapters from companies like 3Ware are starting to be much faster than software RAID with lower CPU consumption.

Use non-RAID SCSI controllers if you want high performance and low CPU consumption with software RAID.  The write-combining and TCQ of SCSI is well suited to SW RAID.  Note that if you use HW RAID controllers for SW RAID, expect slightly better performance than in their HW RAID mode, but much higher CPU consumption, as they make for terrible JBOD SCSI controllers.  This is especially true of the HP smartarray controllers with their Linux drivers.

- Luke

pgsql-performance by date

Next:From: Michael StoneDate: 2005-09-25 18:13:52
Subject: Re: Advice on RAID card
Previous:From: Simon RiggsDate: 2005-09-25 17:45:30
Subject: Re: [PERFORM] Releasing memory during External sorting?

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