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