Re: pg_xlog safety - Mailing list pgsql-general

From Bruce Momjian
Subject Re: pg_xlog safety
Date
Msg-id 200301262226.h0QMQFl12542@candle.pha.pa.us
Whole thread Raw
In response to Re: pg_xlog safety  (Andrew Sullivan <andrew@libertyrms.info>)
Responses Re: pg_xlog safety
List pgsql-general
Andrew Sullivan wrote:
> On Tue, Jan 21, 2003 at 03:43:40PM -0500, Vivek Khera wrote:
>
> > So this leads me to my question: one of the tips for performance is to
> > move the pg_xlog to its own disk.  Now that I have a spare disk I was
> > considering moving pg_xlog there.  However, that's the only disk that
>
> Test this first.  On our Sun A5200 arrays, configured using Veritas
> and RAID 1+0, I have tried several times and failed to discover a
> performance andvantage by putting the WAL on another disk or pair of
> disks.  (In other configurations, the same is not the case.)

If you raid has battery-backed RAM cach in your controller, there is no
advantage to putting WAL on a separate disk --- was that the case?

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: I was spoiled by the MySQL timestamp field
Next
From: jerome
Date:
Subject: getting weekly total based on daily...