Skip site navigation (1) Skip section navigation (2)

Re: ext4 finally doing the right thing

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: (view raw, whole thread or download thread mbox)
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.

In response to

pgsql-performance by date

Next:From: elias ghanemDate: 2010-01-21 16:14:38
Subject: Slow update query
Previous:From: Alvaro HerreraDate: 2010-01-21 15:51:51
Subject: Re: New server to improve performance on our large and busy DB - advice?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group