From: Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
To: mark@mark.mielke.cc <mark@mark.mielke.cc>
Cc: Luke Lonergan <llonergan@greenplum.com>
Cc: Michael Stone <mstone+postgres@mathom.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: setting up raid10 with more than 4 drives
Date: Thu, 31 May 2007 07:24:40 +0530
Message-ID: <a97c77030705301854y7c24355cu3b8a1d911cea1b92@mail.gmail.com> (raw)
In-Reply-To: <20070530204134.GA20983@mark.mielke.cc>
References: <C3E62232E3BCF24CBA20D72BFDCB6BF802AF2F1B@MI8NYCMAIL08.Mi8.com>
<C282EBA1.31B8C%llonergan@greenplum.com>
<20070530155733.GA18830@mark.mielke.cc>
<a97c77030705301258u1ef4e895h8fd32bfcadf22248@mail.gmail.com>
<20070530204134.GA20983@mark.mielke.cc>
On 5/31/07, mark@mark.mielke.cc <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/
>
>
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: mallah.rajesh@gmail.com, mark@mark.mielke.cc, llonergan@greenplum.com, mstone+postgres@mathom.us
Subject: Re: setting up raid10 with more than 4 drives
In-Reply-To: <a97c77030705301854y7c24355cu3b8a1d911cea1b92@mail.gmail.com>
References: <C3E62232E3BCF24CBA20D72BFDCB6BF802AF2F1B@MI8NYCMAIL08.Mi8.com> <C282EBA1.31B8C%llonergan@greenplum.com> <20070530155733.GA18830@mark.mielke.cc> <a97c77030705301258u1ef4e895h8fd32bfcadf22248@mail.gmail.com> <20070530204134.GA20983@mark.mielke.cc> <a97c77030705301854y7c24355cu3b8a1d911cea1b92@mail.gmail.com>
* 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