From: "E(dot)Rodichev" <er(at)sai(dot)msu(dot)su>
To: pgsql-hackers(at)postgresql(dot)org
Cc: oleg(at)sai(dot)msu(dot)su
Subject:
Date: 2005-02-15 15:59:10
Message-ID: Pine.GSO.4.62.0502151838230.7441@ra.sai.msu.su
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

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.

Looks like this is the same for 8.0.1.

Did somebody resolved this issue successfully?

_________________________________________________________________________
Evgeny Rodichev Sternberg Astronomical Institute
email: er(at)sai(dot)msu(dot)su Moscow State University
Phone: 007 (095) 939 2383
Fax: 007 (095) 932 8841 http://www.sai.msu.su/~er

Browse pgsql-hackers by date

  From Date Subject
Next Message Magnus Hagander 2005-02-15 16:33:02 Re:
Previous Message Nicolai Tufar 2005-02-15 14:29:27 Re: [pgsql-hackers-win32] Repleacement for src/port/snprintf.c