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

opinion on RAID choice

From: Vivek Khera <khera(at)kcilink(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: opinion on RAID choice
Date: 2003-08-28 21:16:41
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
I just ran a handful of tests on a 14-disk array on a SCSI hardware
RAID card.

From some quickie benchmarks using the bonnie++ benchmark, it appears
that the RAID5 across all 14 disks is a bit faster than RAID50 and
noticeably faster than RAID10...

Sample numbers for a 10Gb file (speed in Kbytes/second)
                   RAID5     RAID50       RAID10       
sequential write:  39728     37568        23533	       
read/write file:   13831     13289        11400             
sequential read:   52184     51529  	  54222     

Hardware is a Dell 2650 dual Xeon, 4GB Ram, PERC3/DC RAID card with
14 external U320 SCSI 15kRPM drives.  Software is FreeBSD 4.8 with the
default newfs settings.

The RAID drives were configured with 32k stripe size.  From informal
tests it doesn't seem to make much difference in the bonnie++
benchmark to go with 64k stripe on the RAID10 (didn't test it with
RAID5 or RAID50).  They say use larger stripe size for sequential
access, and lower for random access.

My concern is speed.  Any RAID config on this system has more disk
space than I will need for a LOOONG time.

My Postgres load is a heavy mix of select/update/insert.  ie, it is a
very actively updated and read database.

The conventional wisdom has been to use RAID10, but with 14 disks, I'm
kinda leaning toward RAID50 or perhaps just RAID5.

Has anyone else done similar tests of different RAID levels?  What
were your conclusions?

Raw output from bonnie++ available upon request.


pgsql-performance by date

Next:From: scott.marloweDate: 2003-08-28 21:26:14
Subject: Re: opinion on RAID choice
Previous:From: Jan WieckDate: 2003-08-28 21:00:02
Subject: Re: Replication Ideas

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