From: Ron <rjpeace@earthlink.net>
To: Michael Stone <mstone+postgres@mathom.us>
To: pgsql-performance@postgresql.org
Subject: Re: What's the best hardver for PostgreSQL 8.1?
Date: Tue, 27 Dec 2005 14:57:13 -0500
Message-ID: <6.2.5.6.0.20051227144047.01dbe940@earthlink.net> (raw)
In-Reply-To: <20051227190516.GB6811@mathom.us>
References: <200512212209.50234.caseroj@comcast.net>
<200512212231.55100.caseroj@comcast.net>
<20051224135042.484c6e32.frank@wiles.org>
<6.2.5.6.0.20051224161551.01dc5d98@earthlink.net>
<Pine.LNX.4.62.0512241350010.2807@qnivq.ynat.uz>
<6.2.5.6.0.20051224172653.01dd4c08@earthlink.net>
<20051225173755.GA6986@mathom.us>
<33c6269f0512260932g38c9b7a4uc2aba00f72ff77@mail.gmail.com>
<20051227133526.GA6811@mathom.us>
<6.2.5.6.0.20051227110304.01dc1000@earthlink.net>
<20051227190516.GB6811@mathom.us>
At 02:05 PM 12/27/2005, Michael Stone wrote:
>On Tue, Dec 27, 2005 at 11:50:16AM -0500, Ron wrote:
>>Sorry. A decade+ RWE in production with RAID 5 using controllers
>>as bad as Adaptec and as good as Mylex, Chaparral, LSI Logic
>>(including their Engino stuff), and Xyratex under 5 different OS's
>>(Sun, Linux, M$, DEC, HP) on each of Oracle, SQL Server, DB2,
>>mySQL, and pg shows that RAID 5 writes are slower than RAID 5 reads
>
>What does that have to do with anything? That wasn't the question...
Your quoted position is "there isn't a 'RAID 5 penalty' assuming
you've got a reasonably fast controller and you're doing large
sequential writes (or have enough cache that random writes can be
batched as large sequential writes)."
My experience across a wide range of HW, OSs, DBMS, and applications
says you are wrong. Given enough IO, RAID 5 takes a bigger
performance hit for writes than RAID 10 does.
Enough IO, sequential or otherwise, will result in a situation where
a RAID 10 array using the same number of HDs (and therefore of ~1/2
the usable capacity) will have better write performance than the
equivalent RAID 5 built using the same number of HDs.
There is a 'RAID 5 write penalty'.
Said RAID 10 array will also be more robust than a RAID 5 built using
the same number of HDs.
OTOH, that does not make RAID 5 "bad". Nor are statements like
"Never use RAID 5!" realistic or reasonable.
Also, performance is not the only or even most important reason for
choosing RAID 10 or RAID 50 over RAID 5. Robustness considerations
can be more important than performance ones.
cheers,
Ron
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 using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: rjpeace@earthlink.net, mstone+postgres@mathom.us
Subject: Re: What's the best hardver for PostgreSQL 8.1?
In-Reply-To: <6.2.5.6.0.20051227144047.01dbe940@earthlink.net>
* 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