Re: Checkpoint spikes

From: Andres Freund <andres(at)anarazel(dot)de>
To: pgsql-performance(at)postgresql(dot)org
Cc: Greg Smith <greg(at)2ndquadrant(dot)com>, Richard Neill <rn214(at)cam(dot)ac(dot)uk>, Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
Subject: Re: Checkpoint spikes
Date: 2009-12-09 02:13:06
Message-ID: 200912090313.06864.andres@anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Andy Colson 2009-12-09 13:31:19 Re: Load experimentation
Previous Message Greg Smith 2009-12-09 02:05:40 Re: Checkpoint spikes