| From: | "Michael Paesold" <mpaesold(at)gmx(dot)at> |
|---|---|
| To: | "Magnus Hagander" <mha(at)sollentuna(dot)net>, "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <pgsql-hackers(at)postgresql(dot)org>, <pgsql-hackers-win32(at)postgresql(dot)org>, "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com> |
| Subject: | Re: win32 performance - fsync question |
| Date: | 2005-02-27 13:46:06 |
| Message-ID: | 003e01c51cd2$b037bd40$0a01a8c0@zaphod |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-hackers-win32 |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2005-02-27 18:07:16 | snprintf causes regression tests to fail |
| Previous Message | Magnus Hagander | 2005-02-27 11:26:22 | Re: win32 performance - fsync question |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2005-02-27 18:07:16 | snprintf causes regression tests to fail |
| Previous Message | Magnus Hagander | 2005-02-27 11:26:22 | Re: win32 performance - fsync question |