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

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

From: "Guoping Zhang" <guoping(dot)zhang(at)nec(dot)com(dot)au>
To: "'Guillaume Smet'" <guillaume(dot)smet(at)gmail(dot)com>
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-28 05:18:08
Message-ID: 004301c66a83$234bd470$74304c93@eddy (view raw or flat)
Thread:
Lists: pgsql-performance
Hi, Guillaume,

Thanks for the reply.

I am using wal_sync_methods be open_datasync, which appear much faster than
'fdatasync'.

Regards,
Guoping

-----Original Message-----
From: Guillaume Smet [mailto:guillaume(dot)smet(at)gmail(dot)com]
Sent: 2006Äê4ÔÂ27ÈÕ 19:26
To: guoping(dot)zhang(at)nec(dot)com(dot)au
Cc: pgsql-performance(at)postgresql(dot)org; Guoping Zhang (E-mail)
Subject: Re: [PERFORM] how unsafe (or worst scenarios) when setting
fsync OFF for postgresql


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

pgsql-performance by date

Next:From: Guoping ZhangDate: 2006-04-28 05:58:06
Subject: Re: how unsafe (or worst scenarios) when setting fsync OFF for postgresql
Previous:From: Tom LaneDate: 2006-04-28 05:05:48
Subject: Re: how unsafe (or worst scenarios) when setting fsync

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