X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C79BA5336C for ; Mon, 18 Apr 2005 15:24:42 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 26765-02 for ; Mon, 18 Apr 2005 18:24:29 +0000 (GMT) Received: from stark.xeocode.com (stark.xeocode.com [216.58.44.227]) by svr1.postgresql.org (Postfix) with ESMTP id 651D353247 for ; Mon, 18 Apr 2005 15:24:28 -0300 (ADT) Received: from localhost ([127.0.0.1] helo=stark.xeocode.com) by stark.xeocode.com with smtp (Exim 3.36 #1 (Debian)) id 1DNaut-0007bI-00; Mon, 18 Apr 2005 14:24:15 -0400 To: Jacques Caron Cc: Alex Turner , Greg Stark , William Yu , pgsql-performance@postgresql.org Subject: Re: How to improve db performance with $7K? References: <425EBA0C.6030804@sfnet.cc> <87pswsku6e.fsf@stark.xeocode.com> <33c6269f0504180817511b27a3@mail.gmail.com> <878y3gks3p.fsf@stark.xeocode.com> <33c6269f05041809566abf91d2@mail.gmail.com> <6.2.0.14.0.20050418192528.04238088@pop.interactivemediafactory.net> In-Reply-To: <6.2.0.14.0.20050418192528.04238088@pop.interactivemediafactory.net> From: Greg Stark Organization: The Emacs Conspiracy; member since 1992 Date: 18 Apr 2005 14:24:14 -0400 Message-ID: <873btokkoh.fsf@stark.xeocode.com> Lines: 14 User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.3 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.007 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/422 X-Sequence-Number: 11819 Jacques Caron writes: > When writing: > - in RAID 0, 1 drive > - in RAID 1, RAID 0+1 or 1+0, 2 drives > - in RAID 5, you need to read on all drives and write on 2. Actually RAID 5 only really needs to read from two drives. The existing parity block and the block you're replacing. It just xors the old block, the new block, and the existing parity block to generate the new parity block. -- greg