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