Re: Low performance on Windows problem

From: "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>
To: "Dalibor Sramek" <dali(at)insula(dot)cz>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Low performance on Windows problem
Date: 2005-09-14 17:10:32
Message-ID: 6EE64EF3AB31D5448D0007DD34EEB3417DD337@Herge.rcsinc.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> in the 10 ms range. Definitely not 800 ms. The 8.1 has the same
problem.
>
> Just for the record: the server PC is Dell Precision 330 with 3Com
3C920
> integrated network card. OS MS Windows Professional 2002 with service
pack
> 2. There is Symantec Antivirus installed - which I have (hopefully)
> completely disabled.

Try throwing in another network card and see if it helps. Next step is
to try twinking tcp settings
(http://support.microsoft.com/default.aspx?scid=kb;en-us;314053) and see
if that helps. Beyond that, try playing the update driver game. If you
are still having problems, try receiving bigger and bigger results to
see where problem occurs. 1-2k range suggests mtu problem, 4-8k range
suggests tcp receive window problem.

Beyond that, I'm stumped, uh, buy Opteron? :)

Merlin

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2005-09-14 17:54:46 Re: About method of PostgreSQL's Optimizer
Previous Message Jonah H. Harris 2005-09-14 16:36:37 Re: About method of PostgreSQL's Optimizer