pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Vincent van Leeuwen <pgsql.spam@vinz.nl>
To: pgsql-performance@postgresql.org
Subject: Re: the RAID question, again
Date: Tue, 22 Apr 2003 14:11:50 +0200
Message-ID: <20030422121150.GU1836@md2.mediadesign.nl> (raw)
In-Reply-To: <20030416193256.25788.h006.c001.wm@mail.dilger.cc.criticalpath.net>
References: <20030416193256.25788.h006.c001.wm@mail.dilger.cc.criticalpath.net>

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/




view thread (7+ messages)  latest in thread

Message-ID: <20030422121150.GU1836@md2.mediadesign.nl>
Permalink:  ../20030422121150.GU1836@md2.mediadesign.nl/
Also on:    postgresql.org/message-id/20030422121150.GU1836@md2.mediadesign.nl

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: pgsql.spam@vinz.nl
  Subject: Re: the RAID question, again
  In-Reply-To: <20030422121150.GU1836@md2.mediadesign.nl>
  References: <20030416193256.25788.h006.c001.wm@mail.dilger.cc.criticalpath.net> <20030422121150.GU1836@md2.mediadesign.nl>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox