Re: win32 performance - fsync question - Mailing list pgsql-hackers

From Michael Paesold
Subject Re: win32 performance - fsync question
Date
Msg-id 003e01c51cd2$b037bd40$0a01a8c0@zaphod
Whole thread Raw
In response to Re: win32 performance - fsync question  ("Magnus Hagander" <mha@sollentuna.net>)
Responses Re: [pgsql-hackers-win32] win32 performance - fsync question
List pgsql-hackers
Magnus Hagander wrote:


>> Magnus Hagander wrote:
>>> > Magnus prepared a trivial patch which added the O_SYNC flag
>>> > for windows and mapped it to FILE_FLAG_WRITE_THROUGH in
>>> > win32_open.c.
[snip]

> Michael Paesold wrote:
>>The original patch did not have any documentation. Have you
>>added some? Since this has to be configured in GUC (wal_sync_method),
>>the implications should be documented somewhere, no?

>The patch just implements behaviour that was already documented (for
>unix) on a new platform (win32). The documentation in general appears >to
>have very little information on what to pick there, though ;-)

Reading your mails about the pull-the-plug tests, I see that at least with
write caching enabled, fsync is more secure on win32 than open_sync. I.e.
one should disable write caching for use with open_sync. Also open_sync
seems to perform much better. All that information would be nice to have in
the docs.

Best Regards,
Michael Paesold


pgsql-hackers by date:

Previous
From: "Michael Paesold"
Date:
Subject: Re: win32 performance - fsync question
Next
From: "Magnus Hagander"
Date:
Subject: Re: [pgsql-hackers-win32] win32 performance - fsync question