Re: Changing the default wal_sync_method to open_sync for Win32? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Changing the default wal_sync_method to open_sync for Win32?
Date
Msg-id 20025.1111033569@sss.pgh.pa.us
Whole thread Raw
In response to Changing the default wal_sync_method to open_sync for Win32?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Changing the default wal_sync_method to open_sync for  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Notice we never default to open_sync.  However, on Win32, Magnus got a
> 60% speedup by using open_sync, implemented using
> FILE_FLAG_WRITE_THROUGH.  Now, because this the fastest on Win32, I
> think we should default to open_sync on Win32.  The attached patch
> implements this.

... and breaks open_datasync for all other platforms ...

            regards, tom lane

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Changing the default wal_sync_method to open_sync for Win32?
Next
From: Bruce Momjian
Date:
Subject: Re: [pgsql-hackers-win32] win32 performance - fsync question