From: Christopher Browne <cbbrowne@libertyrms.info>
To: pgsql-performance@postgresql.org
Subject: Re: best arrangement of 3 disks for (insert) performance - Dell
Date: Fri, 12 Sep 2003 16:47:22 -0400
Message-ID: <60fzj1raxx.fsf@dev6.int.libertyrms.info> (raw)
References: <OF05C143F9.4A165099-ON88256D9F.005D4EB2-88256D9F.005DAC3B@sybex.com>
TDyson@sybex.com ("Thom Dyson") writes:
> The Dell PERC controllers have a very strong reputation for terrible
> performance. If you search the archives of the Dell Linux Power
> Edge list (dell.com/linux), you will find many, many people who get
> better performance from software RAID, rather than the hw RAID on
> the PERC. Having said that, the 3/SC might be one of the better
> PERC controllers. I would spend and hour or two and benchmark hw
> vs. sw before I committed to either one.
I can't agree with that.
1. If you search the archives for messages dated a couple of years
ago, you can find lots of messages indicating terrible performance.
Drivers are not cast in concrete; there has been a LOT of change to
them since then.
2. The second MAJOR merit to hardware RAID is the ability to hot-swap
drives. Software RAID doesn't help with that at all.
3. The _immense_ performance improvement that can be gotten out of
these controllers comes from having fsync() turn into a near no-op
since changes can be committed to the 128K battery-backed cache REALLY
QUICKLY.
That is something you should avoid doing with software RAID in any
case where you actually care about your data.
That third part is where Big Wins come. It is the very same sort of
"big win from cacheing" that we saw, years ago, when we improved
system performance _immensely_ by adding a mere 16 bytes of cache by
buying serial controller cards with cacheing UUARTs. It is akin to
the way SCSI controllers got pretty big performance improvements by
adding 256 bytes of tagged command cache.
--
output = ("cbbrowne" "@" "libertyrms.info")
<http://dev6.int.libertyrms.com/;
Christopher Browne
(416) 646 3304 x124 (land)
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: cbbrowne@libertyrms.info
Subject: Re: best arrangement of 3 disks for (insert) performance - Dell
In-Reply-To: <60fzj1raxx.fsf@dev6.int.libertyrms.info>
References: <OF05C143F9.4A165099-ON88256D9F.005D4EB2-88256D9F.005DAC3B@sybex.com> <60fzj1raxx.fsf@dev6.int.libertyrms.info>
* 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