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 E6ADA568B4 for ; Tue, 15 Mar 2005 16:18:42 +0000 (GMT) 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 91078-03 for ; Tue, 15 Mar 2005 16:18:40 +0000 (GMT) Received: from ivimey.org (i-194-106-52-201.freedom2surf.net [194.106.52.201]) by svr1.postgresql.org (Postfix) with ESMTP id B4FC2568C4 for ; Tue, 15 Mar 2005 16:18:38 +0000 (GMT) Received: from gandalf.ivimey.org ([192.168.0.8] helo=gandalf) by gatemaster.ivimey.org with esmtp (Exim 4.44) id 1DBEkB-0002FF-7b; Tue, 15 Mar 2005 16:18:23 +0000 From: "Ruth Ivimey-Cook" To: "'Guy'" , "'Michael Tokarev'" , "'Arshavir Grigorian'" Cc: , Subject: Effect of Stripe Size (was Postgres on RAID5) Date: Tue, 15 Mar 2005 16:17:55 -0000 Organization: At Home MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook, Build 11.0.6353 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 In-Reply-To: <200503142349.j2ENnG510033@www.watkins-home.com> Thread-Index: AcUo6T0/QXzy6oicQJ+4yF22n8922QABNl2wACLx38A= Message-Id: <20050315161838.B4FC2568C4@svr1.postgresql.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.754 tagged_above=0 required=5 tests=FORGED_RCVD_HELO, MSGID_FROM_MTA_ID X-Spam-Level: * X-Archive-Number: 200503/402 X-Sequence-Number: 11107 Folks, > You said: > "If your write size is smaller than chunk_size*N (N = number > of data blocks in a stripe), in order to calculate correct > parity you have to read data from the remaining drives." > > Neil explained it in this message: > http://marc.theaimsgroup.com/?l=linux-raid&m=108682190730593&w=2 Having read that and the recent posts: Has anyone done any performance checks on the md code to determine what, if any, effect the stripe size has on performance? One might suppose the variables would be stripe size, file size and read vs write. Possibly number of drives in array, too. Reason for asking: When I set up my raid5 array, I chose a stripe of 256K, on the grounds that a large number of the files on the drive are multi-megabytes (fairly evenly in the 20MB - 100MB range) and I supposed that a large stripe would speed things up for those files. Was I right? Regards, Ruth