Re: Checkpoint spikes - Mailing list pgsql-performance

From Andres Freund
Subject Re: Checkpoint spikes
Date
Msg-id 200912090313.06864.andres@anarazel.de
Whole thread Raw
In response to Re: Checkpoint spikes  (Greg Smith <greg@2ndquadrant.com>)
List pgsql-performance
On Wednesday 09 December 2009 03:05:40 Greg Smith wrote:
> On Linux having the WAL on a separate disk can improve things much more
> than you might expect, simply because of how brain-dead the filesystem
> fsync implementation is.  Reducing the seeks for WAL traffic can help a
> lot too.
Not using ext3's data=ordered helps massively already.

Andres

pgsql-performance by date:

Previous
From: Greg Smith
Date:
Subject: Re: Checkpoint spikes
Next
From: Andy Colson
Date:
Subject: Re: Load experimentation