On Thursday, June 5, 2003, at 11:04 AM, Josh Berkus wrote:
>>> So, is there a postgresql.conf setting for the location of the WAL
>>> or something?
> No, not yet. In 7.4, there will be a compile-time option for the
> You can symlink it, or mount it. I use the latter method:
> Also, I've found that 3-disk RAID 5 gives about the worst data writing
> performance on Postgresql of any disk configuation; about 1/3 the
> speed of
> raw SCSI, worse if WAL is on the same array. Increasing the number of
> ... or switching to RAID 1+0 ... makes a large difference.
Actually, it turns out that it's RAID 5 with 4 disks. Should be better
performance then, I hope.
Thanks for the help!
David Wheeler AIM: dwTheory
david(at)kineticode(dot)com ICQ: 15726394
http://kineticode.com/ Yahoo!: dew7e
Kineticode. Setting knowledge in motion.[sm]
In response to
sfpug by date
|Next:||From: Josh Berkus||Date: 2003-06-13 16:02:57|
|Subject: Spam getting through?|
|Previous:||From: Josh Berkus||Date: 2003-06-05 18:04:47|
|Subject: Re: Transaction Log|