Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 4DFD09FB8DC for ; Wed, 30 May 2007 22:54:50 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 31621-08 for ; Wed, 30 May 2007 22:54:39 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.248]) by postgresql.org (Postfix) with ESMTP id 0ABCA9FB88D for ; Wed, 30 May 2007 22:54:42 -0300 (ADT) Received: by an-out-0708.google.com with SMTP id c36so4081ana for ; Wed, 30 May 2007 18:54:40 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=M8Q06gebMGmIjLZc+32nhAuCR6v//WfaQateUihlQrk0SKHjGw0oI8n/4AFA7mDIlOWKScUBDa6Zs+dza8n3ZWoFLKBm8ap27NcOaPmD9MQ7spNA2yUGt4aG6KQcPvrYp+LVKU87Ex24GdmGUne7Q7oE4DT7qUila4WqOKkF8Qw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=ZTZyvmiC+on5VGMqT9TM+NWAJGF+NceK1nMUxW5OGsW+tSVx/zQPqRM8sIkmAwzeVa9/bj42h0EvX5ax9DokFrFdN9ipNx3iJX6ci0c9WTLneo/UaLpe9KSUaCZtHxYWgXBSvE0Q7bkx3OHKW/NX0nc+iJ59ntSaUBZapM16A8k= Received: by 10.100.202.13 with SMTP id z13mr53180anf.1180576480805; Wed, 30 May 2007 18:54:40 -0700 (PDT) Received: by 10.100.121.15 with HTTP; Wed, 30 May 2007 18:54:40 -0700 (PDT) Message-ID: Date: Thu, 31 May 2007 07:24:40 +0530 From: "Rajesh Kumar Mallah" To: "mark@mark.mielke.cc" Subject: Re: setting up raid10 with more than 4 drives Cc: "Luke Lonergan" , "Michael Stone" , pgsql-performance@postgresql.org In-Reply-To: <20070530204134.GA20983@mark.mielke.cc> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <20070530155733.GA18830@mark.mielke.cc> <20070530204134.GA20983@mark.mielke.cc> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/633 X-Sequence-Number: 25023 On 5/31/07, mark@mark.mielke.cc wrote: > On Thu, May 31, 2007 at 01:28:58AM +0530, Rajesh Kumar Mallah wrote: > > i am still not clear what is the best way of throwing in more > > disks into the system. > > does more stripes means more performance (mostly) ? > > also is there any thumb rule about best stripe size ? (8k,16k,32k...) > > It isn't that simple. RAID1 should theoretically give you the best read > performance. If all you care about is read, then "best performance" would > be to add more mirrors to your array. > > For write performance, RAID0 is the best. I think this is what you mean > by "more stripes". > > This is where RAID 1+0/0+1 come in. To reconcile the above. Your question > seems to be: I have a RAID 1+0/0+1 system. Should I add disks onto the 0 > part of the array? Or the 1 part of the array? > My conclusion to you would be: Both, unless you are certain that you load > is scaled heavily towards read, in which case the 1, or if scaled heavily > towards write, then 0. thanks . this answers to my query. all the time i was thinking of 1+0 only failing to observe the 0+1 part in it. > > Then comes the other factors. Do you want redundancy? Then you want 1. > Do you want capacity? Then you want 0. Ok. > > There is no single answer for most people. > > For me, stripe size is the last decision to make, and may be heavily > sensitive to load patterns. This suggests a trial and error / benchmarking > requirement to determine the optimal stripe size for your use. thanks. mallah. > > Cheers, > mark > > -- > mark@mielke.cc / markm@ncf.ca / markm@nortel.com __________________________ > . . _ ._ . . .__ . . ._. .__ . . . .__ | Neighbourhood Coder > |\/| |_| |_| |/ |_ |\/| | |_ | |/ |_ | > | | | | | \ | \ |__ . | | .|. |__ |__ | \ |__ | Ottawa, Ontario, Canada > > One ring to rule them all, one ring to find them, one ring to bring them all > and in the darkness bind them... > > http://mark.mielke.cc/ > >