| 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: | Whole Thread | Raw Message | 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 |