"Bruce Momjian" writes
>
> Yes, we now enable FILE_FLAG_WRITE_THROUGH on Win32 for open_sync and I
> am about to open a discussion whether this should be the default for
> Win32, and whether we should backpatch this to 8.0.X.
Just a short msg: Oracle/SQL Server enable it as default in win32 *no m
Chris Mair wrote:
> Timings are in msec, note that you cannot directly
> compare Windows and Linux Performance, since machines
> were different.
>
> You can, however, compare PG to Firebird, and you
> can see the effect of the 3 varied parametert.
>
> One thing that stands out is how terribly
> b
> One thing that stands out is how terribly bad Windows
> performed with many small single transactions and fsync=true.
>
> Appearantly fsync on Windows is a very costly operation.
What's the hardware? If you're running on disks with write cache
enabled, fsync on windows will write through the