From: Jim Nasby <jnasby@pervasive.com>
To: pgsql-performance@postgresql.org
Subject: FW: pg_xlog on data partition with BBU RAID
Date: Fri, 9 Jun 2006 21:24:47 -0500
Message-ID: <4D27CB1096EF1C408F4BFAB0046EC7B608C241@ausmailid.aus.pervasive.com> (raw)
References: <20060609194116.GD57289@pervasive.com>
<200606091709.55745@hal.medialogik.com>
Forwarding to -performance
From: Alan Hodgson [mailto:ahodgson@simkin.ca]
On Friday 09 June 2006 12:41, "Jim C. Nasby" <jnasby@pervasive.com> wrote:
> Has anyone actually done any testing on this? Specifically, I'm
> wondering if the benefit of adding 2 more drives to a RAID10 outweighs
> whatever penalties there are to having pg_xlog on that RAID10 with all
> the rest of the data.
I have an external array with 1GB of write-back cache, and testing on it
before deployment showed no difference under any workload I could generate
between having pg_xlog on a separate RAID-1 or having it share a RAID-10
with the default tablespace. I left it on the RAID-10, and it has been
fine there. We have a very write-heavy workload.
--
"If a nation expects to be ignorant and free, in a state of civilization,
it expects what never was and never will be." -- Thomas Jefferson
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: jnasby@pervasive.com
Subject: Re: FW: pg_xlog on data partition with BBU RAID
In-Reply-To: <4D27CB1096EF1C408F4BFAB0046EC7B608C241@ausmailid.aus.pervasive.com>
References: <20060609194116.GD57289@pervasive.com> <200606091709.55745@hal.medialogik.com> <4D27CB1096EF1C408F4BFAB0046EC7B608C241@ausmailid.aus.pervasive.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