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

Re: the RAID question, again

From: Vincent van Leeuwen <pgsql(dot)spam(at)vinz(dot)nl>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: the RAID question, again
Date: 2003-04-22 12:11:50
Message-ID: 20030422121150.GU1836@md2.mediadesign.nl (view raw or flat)
Thread:
Lists: pgsql-performance
On 2003-04-16 19:32:54 -0700, Nikolaus Dilger wrote:
> One improvement area may be to put all 6 disks into a
> RAID 10 group.  That way you have more I/O bandwith. 

A concern I have about that setup is that a large WAL write will have to wait
for 6 spindles to write the data before returning instead of 2 spindles. But
as you say it does create way more I/O bandwidth. I think I'll just test that
when the box is here instead of speculating further :)

> One watchout is that the main memory of your machine
> may be better than the one of your RAID controller.
> The RAID controller has Integrated 128MB PC133 ECC
> SDRAM.  You did not state what kind of memory your
> server has.
> 

On 2003-04-16 20:20:50 -0700, Josh Berkus wrote:
> Nickolaus has a good point.   With a high-end Linux server, and a medium-end
> RAID card, it's sometimes faster to use Linux software RAID than harware
> raid.  Not all the time, though.

I've heard rumors that software raid performs poor when stacking raid layers
(raid 0 on raid 1). Not sure if that's still true though. My own experiences
with linux software raid (raid 5 on a low-cost fileserver for personal use)
are very good (especially in the reliability department, I've recovered from
two-disk failures due to controllers hanging up with only a few percent data
loss), although I've never been overly concerned with performance on that
setup so haven't really tested that.

But if this controller is medium-end, could anyone recommend a high-end RAID
card that has excellent linux support? One of the things I especially like
about ICP Vortex products is the official linux support and the excellent
software utility for monitoring and (re)configuring the raid arrays. Comes in
handy when replacing hot-spares and rebuilding failed arrays while keeping
the box running :)

Vincent van Leeuwen
Media Design - http://www.mediadesign.nl/


In response to

Responses

pgsql-performance by date

Next:From: Josh BerkusDate: 2003-04-22 17:18:57
Subject: Re: the RAID question, again
Previous:From: Kevin BrownDate: 2003-04-22 11:44:30
Subject: Re: [PERFORM] Foreign key performance

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