Re: how unsafe (or worst scenarios) when setting fsync OFF for postgresql

From: "Guillaume Smet" <guillaume(dot)smet(at)gmail(dot)com>
To: guoping(dot)zhang(at)nec(dot)com(dot)au
Cc: pgsql-performance(at)postgresql(dot)org, "Guoping Zhang (E-mail)" <guopingz(at)nstc(dot)nec(dot)com(dot)au>
Subject: Re: how unsafe (or worst scenarios) when setting fsync OFF for postgresql
Date: 2006-04-27 09:26:18
Message-ID: 1d4e0c10604270226s53e261e9m943bf44766c880bf@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Guoping,

On 4/27/06, Guoping Zhang <guoping(dot)zhang(at)nec(dot)com(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Michael Stone 2006-04-27 11:43:42 Re: Introducing a new linux readahead framework
Previous Message Mikael Carneholm 2006-04-27 07:42:54 Re: how unsafe (or worst scenarios) when setting fsync OFF for postgresql