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 > bad Windows performed with many small single > transactions and fsync=true. > > Appearantly fsync on Windows is a very costly > operation.
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. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly