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

Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?

From: Marti Raudsepp <marti(at)juffo(dot)org>
To: Greg Smith <greg(at)2ndquadrant(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
Date: 2010-11-01 01:29:41
Message-ID: AANLkTikoY=XQJnCWyHioP5dTXvvdCU3YBwCVuRDkG-jF@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Sun, Oct 31, 2010 at 21:59, Greg Smith <greg(at)2ndquadrant(dot)com> wrote:
> open_datasync support was just added to Linux itself very recently.

Oh I didn't realize it was a new feature. Indeed O_DSYNC support was
added in 2.6.33

It seems like bad behavior on PostgreSQL's part to default to new,
untested features.

I have updated the tuning wiki page with my understanding of the problem:
http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server#wal_sync_method_wal_buffers

Regards,
Marti

In response to

pgsql-performance by date

Next:From: Jon NelsonDate: 2010-11-01 01:48:32
Subject: Re: [PERFORM] typoed column name, but postgres didn't grump
Previous:From: Andres FreundDate: 2010-10-31 23:10:28
Subject: Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?

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