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

Re: Changing the default wal_sync_method to open_sync for Win32?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Magnus Hagander <mha(at)sollentuna(dot)net>,pgsql-hackers(at)postgresql(dot)org, pgsql-hackers-win32(at)postgresql(dot)org,Merlin Moncure <merlin(dot)moncure(at)rcsonline(dot)com>
Subject: Re: Changing the default wal_sync_method to open_sync for Win32?
Date: 2005-03-17 04:26:09
Message-ID: 20025.1111033569@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-hackers-win32
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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

In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2005-03-17 04:29:09
Subject: Re: [pgsql-hackers-win32] win32 performance - fsync question
Previous:From: Bruce MomjianDate: 2005-03-17 04:20:12
Subject: Changing the default wal_sync_method to open_sync for Win32?

pgsql-hackers-win32 by date

Next:From: Bruce MomjianDate: 2005-03-17 04:29:09
Subject: Re: [pgsql-hackers-win32] win32 performance - fsync question
Previous:From: Bruce MomjianDate: 2005-03-17 04:20:12
Subject: Changing the default wal_sync_method to open_sync for Win32?

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