> Question 1: Is your writeback cache really disabled in Linux, on the > harddrive? Windows fsync will *write through the disk write cache* if > the driver is properly implemented. AFAIK, on Linux if write cache is > enabled on the drive, fsync will only get into the cache. > 800tps sounds unreasonably high on a notebook. > > Question 2: Please try disabling the stats connector and see if that > helps. Merlin Moncure reported some scalability issues with the stats > collector previously. > > > > Several yeas ago (about 1997-1998) Oleg Bartunov and me had > > the same performance results (Linux vs Windows NT + cygwin). > > It was the discussion at this list with resume that the > > reason is the implementation of shared memory under Windows. > > Every IPC operation results the HDD access. > > It shouldn't in 8.0 - at least not on the native win32. Don't know about > cygwin.
The price on win32 for row level stats collector is fairly high. Also the stats collector resets randomly under very high loads. However I don't think this is what's going on here. Also, IPC is out. The win32 IPC implementation is fine, if somewhat slower than linux implementation. It's all about syncing, IMO. Merlin ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match