Postgres Pro
Downloads
Home   >   mailing lists

Re: how unsafe (or worst scenarios) when setting fsync OFF for postgresql - Mailing list pgsql-performance

From Guillaume Smet
Subject Re: how unsafe (or worst scenarios) when setting fsync OFF for postgresql
Date
Msg-id 1d4e0c10604270226s53e261e9m943bf44766c880bf@mail.gmail.com
Whole thread Raw
In response to how unsafe (or worst scenarios) when setting fsync OFF for postgresql  ("Guoping Zhang" <guoping.zhang@nec.com.au>)
Responses Re: how unsafe (or worst scenarios) when setting fsync OFF for postgresql  ("Guoping Zhang" <guoping.zhang@nec.com.au>)
List pgsql-performance
Tree view 
Guoping,

On 4/27/06, Guoping Zhang <guoping.zhang@nec.com.au> wrote:
> We have to looking at setting fsync OFF option for performance reason,

Did you try the other wal sync methods (fdatasync in particular)? I
saw a few posts lately explaining how changing sync method can affect
performances in specific cases.

--
Guillaume

pgsql-performance by date:

Previous
From: "Mikael Carneholm"
Date:
Subject: Re: how unsafe (or worst scenarios) when setting fsync OFF for postgresql
Next
From: Michael Stone
Date:
Subject: Re: Introducing a new linux readahead framework