From: Merlin Moncure <mmoncure@gmail.com>
To: Decibel! <decibel@decibel.org>
Cc: Joe Uhl <joeuhl@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Dell Hardware Recommendations
Date: Fri, 10 Aug 2007 16:23:20 +0530
Message-ID: <b42b73150708100353j75424201nf5ffa646891873e5@mail.gmail.com> (raw)
In-Reply-To: <20070809220502.GE20424@nasby.net>
References: <46BB6F3D.6090608@gmail.com>
<b42b73150708091450t448e3fa0nc778ab87d639603@mail.gmail.com>
<20070809220502.GE20424@nasby.net>
On 8/10/07, Decibel! <decibel@decibel.org> wrote:
> On Thu, Aug 09, 2007 at 05:50:10PM -0400, Merlin Moncure wrote:
> > Raid 10 is usually better for databases but in my experience it's a
> > roll of the dice. If you factor cost into the matrix a SAS raid 05
> > might outperform a SATA raid 10 because you are getting better storage
> > utilization out of the drives (n - 2 vs. n / 2). Then again, you
> > might not.
>
> It's going to depend heavily on the controller and the workload.
> Theoretically, if most of your writes are to stripes that the controller
> already has cached then you could actually out-perform RAID10. But
> that's a really, really big IF, because if the strip isn't in cache you
> have to read the entire thing in before you can do the write... and that
> costs *a lot*.
>
> Also, a good RAID controller can spread reads out across both drives in
> each mirror on a RAID10. Though, there is an argument for not doing
> that... it makes it much less likely that both drives in a mirror will
> fail close enough to each other that you'd lose that chunk of data.
>
> Speaking of failures, keep in mind that a normal RAID5 puts you only 2
> drive failures away from data loss, while with RAID10 you can
> potentially lose half the array without losing any data. If you do RAID5
> with multiple parity copies that does change things; I'm not sure which
> is better at that point (I suspect it matters how many drives are
> involved).
when making hardware recommendations I always suggest to buy two
servers and rig PITR with warm standby. This allows to adjust the
system a little bit for performance over fault tolerance.
Regarding raid controllers, I've found performance to be quite
variable as stated, especially with regards to RAID 5. I've also
unfortunately found bonnie++ to not be very reflective of actual
performance in high stress environments. We have a IBM DS4200 that
bangs out some pretty impressive numbers with our app using sata while
the bonnie++ numbers fairly suck.
merlin
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: mmoncure@gmail.com, decibel@decibel.org, joeuhl@gmail.com
Subject: Re: Dell Hardware Recommendations
In-Reply-To: <b42b73150708100353j75424201nf5ffa646891873e5@mail.gmail.com>
References: <46BB6F3D.6090608@gmail.com> <b42b73150708091450t448e3fa0nc778ab87d639603@mail.gmail.com> <20070809220502.GE20424@nasby.net> <b42b73150708100353j75424201nf5ffa646891873e5@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