From: | David Wheeler <david(at)kineticode(dot)com> |
---|---|
To: | josh(at)agliodbs(dot)com |
Cc: | sfpug(at)postgresql(dot)org |
Subject: | Re: Transaction Log |
Date: | 2003-06-05 18:16:24 |
Message-ID: | D0CF5986-9781-11D7-8177-0003931A964A@kineticode.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | sfpug |
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
>>> log
>>> or something?
>
> No, not yet. In 7.4, there will be a compile-time option for the
> location.
Cool.
> You can symlink it, or mount it. I use the latter method:
Thanks, noted.
> 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
> disks
> ... 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!
Regards,
David
--
David Wheeler AIM: dwTheory
david(at)kineticode(dot)com ICQ: 15726394
http://kineticode.com/ Yahoo!: dew7e
Jabber: Theory(at)jabber(dot)org
Kineticode. Setting knowledge in motion.[sm]
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2003-06-13 16:02:57 | Spam getting through? |
Previous Message | Josh Berkus | 2003-06-05 18:04:47 | Re: Transaction Log |