Re: [PERFORM] interesting benchmarks PG/Firebird Linux/Windows fsync/nofsync
"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 matter what* ... Regards, Qingqing ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [PERFORM] interesting benchmarks PG/Firebird Linux/Windows fsync/nofsync
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
Re: [PERFORM] interesting benchmarks PG/Firebird Linux/Windows fsync/nofsync
> 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 write cache *no matter what*. I don't know of any other OS where it will do that. If you don't have a battery backed write cache, then all other configurations are considered very dangerous in case your machine crashes. If you have battery backed write cache, then yes, pg on windows will perform poorly indeed. There is a patch in the queue for 8.0.2, and already applied to 8.1 IIRC, that will fix the bad performance with write-cache on win32. (can't read the PDF, it crashes my adobe reader for some reason. Perhaps it contains the information above...) //Magnus ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
