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

From Magnus Hagander
Subject Re: win32 performance - fsync question
Date
Msg-id 6BCB9D8A16AC4241919521715F4D8BCE4769D3@algol.sollentuna.se
Whole thread Raw
In response to win32 performance - fsync question  ("E.Rodichev" <er@sai.msu.su>)
List pgsql-hackers
>> 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?

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 ;-)


//Magnus

pgsql-hackers by date:

Previous
From: Neil Conway
Date:
Subject: Re: idea for concurrent seqscans
Next
From: "Michael Paesold"
Date:
Subject: Re: win32 performance - fsync question