Re: Advice configuring ServeRAID 8k for performance - Mailing list pgsql-performance

From Pierre C
Subject Re: Advice configuring ServeRAID 8k for performance
Date
Msg-id op.vgzkohd0eorkce@apollo13
Whole thread Raw
In response to Advice configuring ServeRAID 8k for performance  ("Kenneth Cox" <kenstir@gmail.com>)
Responses Re: Advice configuring ServeRAID 8k for performance
Re: Advice configuring ServeRAID 8k for performance
List pgsql-performance
> 1) Should I switch to RAID 10 for performance?  I see things like "RAID
> 5 is bad for a DB" and "RAID 5 is slow with <= 6 drives" but I see
> little on RAID 6.

As others said, RAID6 is RAID5 + a hot spare.

Basically when you UPDATE a row, at some point postgres will write the
page which contains that row.

RAID10 : write the page to all mirrors.
RAID5/6 : write the page to the relevant disk. Read the corresponding page
 from all disks (minus one), compute parity, write parity.

As you can see one small write will need to hog all drives in the array.
RAID5/6 performance for small random writes is really, really bad.

Databases like RAID10 for reads too because when you need some random data
you can get it from any of the mirrors, so you get increased parallelism
on reads too.

> with good redundancy.  My current performance is 85MB/s write, 151 MB/s
> reads

FYI, I get 200 MB/s sequential out of the software RAID5 of 3 cheap
desktop consumer SATA drives in my home multimedia server...


pgsql-performance by date:

Previous
From: Greg Smith
Date:
Subject: Re: Advice configuring ServeRAID 8k for performance
Next
From: Craig James
Date:
Subject: Re: Advice configuring ServeRAID 8k for performance