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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.smet@xxxxxxxxx]
Sent: 2006Äê4ÔÂ27ÈÕ 19:26
To: guoping.zhang@xxxxxxxxxx
Cc: pgsql-performance@xxxxxxxxxxxxxx; 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.zhang@xxxxxxxxxx> 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



[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux