| From: | David Wheeler <david(at)kineticode(dot)com> |
|---|---|
| To: | Josh Berkus <josh(at)agliodbs(dot)com> |
| Cc: | sfpug(at)postgresql(dot)org |
| Subject: | Re: Transaction Log |
| Date: | 2003-06-05 17:35:36 |
| Message-ID: | 1DB587FC-977C-11D7-8177-0003931A964A@kineticode.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | sfpug |
On Thursday, June 5, 2003, at 10:11 AM, Josh Berkus wrote:
> It only benefits performance if it's on a seperate *disk*, not just a
> seperate
> partition. It may help stability to put it on a new partition on the
> same
> disk/array, but not performance.
I believe it's on a separate disk. If it's not, I won't worry about it.
> Also, if you're already on a RAID 1+0 array or a large RAID 5-7 array
> (5 disks
> plus), moving WAL may not be a perceptible benefit at all.
IIRC, it's RAID 5 with 3 disks.
> What OS are you using?
Red Hat Linux 7.3.
So, is there a postgresql.conf setting for the location of the WAL log
or something?
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 | David Wheeler | 2003-06-05 17:39:27 | Re: Transaction Log |
| Previous Message | Josh Berkus | 2003-06-05 17:11:44 | Re: Transaction Log |