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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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