From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-performance@postgresql.org
Subject: Re: best use of an EMC SAN
Date: Wed, 11 Jul 2007 14:27:01 -0400
Message-ID: <20070711182701.GB1241@phlogiston.dyndns.org> (raw)
In-Reply-To: <60zm22x2jo.fsf@dba2.int.libertyrms.com>
References: <D02C9DBC-0127-4B62-ABE3-93646B6A3F9F@fastcrypt.com>
<877ip7avda.fsf@oxford.xeocode.com>
<0DA358AF-4CF3-4910-8E48-26403AE8C0AC@fastcrypt.com>
<60zm22x2jo.fsf@dba2.int.libertyrms.com>
On Wed, Jul 11, 2007 at 01:39:39PM -0400, Chris Browne wrote:
> load causes. A fallout of this is that those disks are likely to be
> worked harder than the disk used for storing "plain old data," with
> the result that if you devote disk to WAL, you'll likely burn thru
> replacement drives faster there than you do for the "POD" disk.
This is true, and in operation can really burn you when you start to
blow out disks. In particular, remember to factor the cost of RAID
re-build into your RAID plans. Because you're going to be doing it,
and if your WAL is near to its I/O limits, the only way you're going
to get your redundancy back is to go noticably slower :-(
> will lose a very little bit in comparison. Andrew Sullivan had a
> somewhat similar finding a few years ago on some old Solaris hardware
> that unfortunately isn't at all relevant today. He basically found
> that moving WAL off to separate disk didn't affect performance
> materially.
Right, but it's not only the hardware that isn't relevant there. It
was also using either 7.1 or 7.2, which means that the I/O pattern
was completely different. More recently, ISTR, we did analysis for
at least one workload that tod us to use separate LUNs for WAL, with
separate I/O paths. This was with at least one kind of array
supported by Awful Inda eXtreme. Other tests, IIRC, came out
differently -- the experience with one largish EMC array was I think
a dead heat between various strategies (so the additional flexibility
of doing everything on the array was worth any cost we were able to
measure). But the last time I had to be responsible for that sort of
test was again a couple years ago. On the whole, though, my feeling
is that you can't make general recommendations on this topic: the
advances in storage are happening too fast to make generalisations,
particularly in the top classes of hardware.
A
--
Andrew Sullivan | ajs@crankycanuck.ca
The plural of anecdote is not data.
--Roger Brinner
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: ajs@crankycanuck.ca
Subject: Re: best use of an EMC SAN
In-Reply-To: <20070711182701.GB1241@phlogiston.dyndns.org>
References: <D02C9DBC-0127-4B62-ABE3-93646B6A3F9F@fastcrypt.com> <877ip7avda.fsf@oxford.xeocode.com> <0DA358AF-4CF3-4910-8E48-26403AE8C0AC@fastcrypt.com> <60zm22x2jo.fsf@dba2.int.libertyrms.com> <20070711182701.GB1241@phlogiston.dyndns.org>
* 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