pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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/
>
>



view thread (27+ messages)  latest in thread

Message-ID: <a97c77030705301854y7c24355cu3b8a1d911cea1b92@mail.gmail.com>
Permalink:  ../a97c77030705301854y7c24355cu3b8a1d911cea1b92@mail.gmail.com/
Also on:    postgresql.org/message-id/a97c77030705301854y7c24355cu3b8a1d911cea1b92@mail.gmail.com

 · 

reply

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