Re: ext4 finally doing the right thing - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: ext4 finally doing the right thing
Date
Msg-id 4B582452020000250002E95B@gw.wicourts.gov
Whole thread Raw
In response to Re: ext4 finally doing the right thing  (Aidan Van Dyk <aidan@highrise.ca>)
List pgsql-performance
>Aidan Van Dyk <aidan@highrise.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

pgsql-performance by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: New server to improve performance on our large and busy DB - advice?
Next
From: Florian Weimer
Date:
Subject: Re: Inserting 8MB bytea: just 25% of disk perf used?