| From: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
|---|---|
| To: | "Greg Smith" <greg(at)2ndquadrant(dot)com>, "Aidan Van Dyk" <aidan(at)highrise(dot)ca> |
| Cc: | "Jeff Davis" <pgsql(at)j-davis(dot)com>,"Greg Stark" <stark(at)mit(dot)edu>, <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: ext4 finally doing the right thing |
| Date: | 2010-01-21 15:54:26 |
| Message-ID: | 4B582452020000250002E95B@gw.wicourts.gov |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
>Aidan Van Dyk <aidan(at)highrise(dot)ca> wrote:
> But, I think that's one of the reasons people usually recommend
> putting WAL separate. Even if it's just another partition on the
> same (set of) disk(s), you get the benefit of not having to wait
> for all the dirty ext3 pages from your whole database FS to be
> flushed before the WAL write can complete on it's own FS.
[slaps forehead]
I've been puzzling about why we're getting timeouts on one of two
apparently identical (large) servers. We forgot to move the pg_xlog
directory to the separate mount point we created for it on the same
RAID. I didn't think to check that until I saw your post.
-Kevin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | elias ghanem | 2010-01-21 16:14:38 | Slow update query |
| Previous Message | Alvaro Herrera | 2010-01-21 15:51:51 | Re: New server to improve performance on our large and busy DB - advice? |