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:[EMAIL PROTECTED] Sent: 2006Äê4ÔÂ27ÈÕ 19:26 To: [EMAIL PROTECTED] Cc: pgsql-performance@postgresql.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 <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
