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
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 |