From: Guillaume Smet <guillaume.smet@gmail.com>
To: guoping.zhang@nec.com.au
Cc: pgsql-performance@postgresql.org, "Guoping Zhang (E-mail)" <guopingz@nstc.nec.com.au>
Subject: Re: how unsafe (or worst scenarios) when setting fsync OFF for postgresql
Date: Thu, 27 Apr 2006 11:26:18 +0200
Message-ID: <1d4e0c10604270226s53e261e9m943bf44766c880bf@mail.gmail.com> (raw)
In-Reply-To: <003b01c669c4$34bbd7b0$74304c93@eddy>
References: <003b01c669c4$34bbd7b0$74304c93@eddy>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: guillaume.smet@gmail.com, guoping.zhang@nec.com.au, guopingz@nstc.nec.com.au
Subject: Re: how unsafe (or worst scenarios) when setting fsync OFF for postgresql
In-Reply-To: <1d4e0c10604270226s53e261e9m943bf44766c880bf@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox