Magnus Hagander wrote:
I've tested the performance of 8.0.1 at my dual-boot notebook (Linux and Windows XP).
I installed 8.0.1 for Linux and Windows XP, and run pgbench -c 1 -t 1000 Under Linux (kernel 2.6.10) I got about 800 tps, and under Windows XP - about 20-24 tps.
Next I switched off virtual memory under Windows (as it was recommended in posting http://www.pgsql.ru/db/mw/msg.html?mid=2026070). It does not help. Without virtual memory I got 15-17 tps.
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.
Also, didn't someone recently report some very significant performance differences Windows networking QoS (Quality of Service) installed? You might try that.
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
