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

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 (view raw or flat)
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

pgsql-performance by date

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

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