X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 741279DCA02 for ; Tue, 27 Dec 2005 15:57:22 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 80835-01 for ; Tue, 27 Dec 2005 15:57:19 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtpauth06.mail.atl.earthlink.net (smtpauth06.mail.atl.earthlink.net [209.86.89.66]) by postgresql.org (Postfix) with ESMTP id 919499DCA42 for ; Tue, 27 Dec 2005 15:57:16 -0400 (AST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=dk20050327; d=earthlink.net; b=ndixv4POttR5bA48CFmbakRHeeGQGFc56aeU8hsZKPjg0J9a7Q9zB6FXArTp3Q2c; h=Received:Message-Id:X-Mailer:Date:To:From:Subject:In-Reply-To:References:Mime-Version:Content-Type:X-ELNK-Trace:X-Originating-IP; Received: from [70.22.244.95] (helo=ron-6d52adff2a6.earthlink.net) by smtpauth06.mail.atl.earthlink.net with asmtp (Exim 4.34) id 1ErKwe-0005Oo-U2; Tue, 27 Dec 2005 14:57:17 -0500 Message-Id: <6.2.5.6.0.20051227144047.01dbe940@earthlink.net> X-Mailer: QUALCOMM Windows Eudora Version 6.2.5.6 Date: Tue, 27 Dec 2005 14:57:13 -0500 To: Michael Stone , pgsql-performance@postgresql.org From: Ron Subject: Re: What's the best hardver for PostgreSQL 8.1? 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> <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> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-ELNK-Trace: acd68a6551193be5d780f4a490ca69563f9fea00a6dd62bc9afe83fe4214205cd2382b41ab71fcf1350badd9bab72f9c350badd9bab72f9c350badd9bab72f9c X-Originating-IP: 70.22.244.95 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.16 required=5 tests=[AWL=0.160] X-Spam-Score: 0.16 X-Spam-Level: X-Archive-Number: 200512/640 X-Sequence-Number: 16461 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