Re: pg_xlog safety
От | Bruce Momjian |
---|---|
Тема | Re: pg_xlog safety |
Дата | |
Msg-id | 200301262226.h0QMQFl12542@candle.pha.pa.us обсуждение исходный текст |
Ответ на | Re: pg_xlog safety (Andrew Sullivan <andrew@libertyrms.info>) |
Ответы |
Re: pg_xlog safety
|
Список | 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 по дате отправления: