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/
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