From: Jeff Davis <pgsql@j-davis.com>
To: Merlin Moncure <mmoncure@gmail.com>
Cc: Bucky Jordan <bjordan@lumeta.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: PowerEdge 2950 questions
Date: Thu, 24 Aug 2006 09:24:50 -0700
Message-ID: <1156436690.15743.181.camel@dogma.v10.wvs> (raw)
In-Reply-To: <b42b73150608240621v453e3aeen44f09cd274f9a7@mail.gmail.com>
References: <78ED28FACE63744386D68D8A9D1CF5D4104ACF@MAIL.corp.lumeta.com>
<1156285374.15743.118.camel@dogma.v10.wvs>
<b42b73150608240621v453e3aeen44f09cd274f9a7@mail.gmail.com>
On Thu, 2006-08-24 at 09:21 -0400, Merlin Moncure wrote:
> On 8/22/06, Jeff Davis <pgsql@j-davis.com> wrote:
> > On Tue, 2006-08-22 at 17:56 -0400, Bucky Jordan wrote:
> > Very interesting. I always hear that people avoid RAID 5 on database
> > servers, but I suppose it always depends. Is the parity calculation
> > something that may increase commit latency vs. a RAID 10? That's
> > normally the explanation that I get.
>
> it's not the parity, it's the seeking. Raid 5 gives you great
> sequential i/o but random is often not much better than a single
> drive. Actually it's the '1' in raid 10 that plays the biggest role
> in optimizing seeks on an ideal raid controller. Calculating parity
> was boring 20 years ago as it inolves one of the fastest operations in
> computing, namely xor. :)
>
Here's the explanation I got: If you do a write on RAID 5 to something
that is not in the RAID controllers cache, it needs to do a read first
in order to properly recalculate the parity for the write.
However, I'm sure they try to avoid this by leaving the write in the
battery-backed cache until it's more convenient to do the read, or maybe
until the rest of the stripe is written in which case it doesn't need to
do the read. I am not sure the actual end effect.
> > > Lastly, re your question on putting the WAL on the RAID10- I currently
> > > have the box setup as RAID5x6 with the WAL and PGDATA all on the same
> > > raidset. I haven't had the chance to do extensive tests, but from
> > > previous readings, I gather that if you have write-back enabled on the
> > > RAID, it should be ok (which it is in my case).
>
> with 6 relatively small disks I think single raid 10 volume is the
> best bet. however above 6 dedicated wal is usually worth considering.
> since wal storage requirements are so small, it's becoming affordable
> to look at solid state for the wal.
>
I've often wondered about that. To a certain degree, that's the same
effect as just having a bigger battery-backed cache, right?
Regards,
Jeff Davis
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 using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: pgsql@j-davis.com, mmoncure@gmail.com, bjordan@lumeta.com
Subject: Re: PowerEdge 2950 questions
In-Reply-To: <1156436690.15743.181.camel@dogma.v10.wvs>
* 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