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

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


//Magnus

Attachment

pgsql-hackers by date:

Previous
From: Thomas Hallgren
Date:
Subject: Re: SPI_finish and RegisterExprContextCallback
Next
From: Doug McNaught
Date:
Subject: Re: sigint psql