"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
Hello,
just recently I held a short course on PG.
One course attendant, Robert Dollinger, got
interested in benchmarking single inserts (since
he currently maintains an application that does
exactly that on Firebird and speed is an issue
there).
He came up with a table that I think is interesti
