Re: win32 performance - fsync question

From: "Michael Paesold" <mpaesold(at)gmx(dot)at>
To: "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>, "Magnus Hagander" <mha(at)sollentuna(dot)net>
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 10:47:15
Message-ID: 054801c51cb9$b53e1780$0a01a8c0@zaphod
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-hackers-win32

Bruce Momjian wrote:

> Patch applied. Thanks.
>
> I assume this is not approprate for 8.0.X.
>
> ---------------------------------------------------------------
>
>
> 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.
>>
>> Attached is this trivial patch. As Merlin says, it needs some more
>> reliability testing. But the numbers are at least reasonable - it
>> *seems* like it's doing the right thing (as long as you turn off write
>> cache). And it's certainly a significant performance increase - it
>> brings the speed almost up to the same as linux.

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?

Best Regards,
Michael Paesold

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Magnus Hagander 2005-02-27 11:15:13 Re: [pgsql-hackers-win32] win32 performance - fsync question
Previous Message Neil Conway 2005-02-27 05:53:42 Re: idea for concurrent seqscans

Browse pgsql-hackers-win32 by date

  From Date Subject
Next Message Magnus Hagander 2005-02-27 11:15:13 Re: [pgsql-hackers-win32] win32 performance - fsync question
Previous Message Bruce Momjian 2005-02-27 00:54:00 Re: win32 performance - fsync question