From: | John R Pierce <pierce(at)hogranch(dot)com> |
---|---|
To: | Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl> |
Cc: | Rob Brown-Bayliss <r(dot)brown(dot)bayliss(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Libpq is very slow on windows but fast on linux. |
Date: | 2010-11-10 07:37:54 |
Message-ID: | 4CDA4BD2.3000902@hogranch.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 11/09/10 11:22 PM, Alban Hertroys wrote:
> Do both machines have similar hardware? If the Linux machine has a
> proper NIC (intel, for example) while the Windows machine has a poor
> NIC (Realtek!), then of course you would get differences in performance.
> I'm not saying Microsofts network stack is particularly good, mind you, just that it isn't necessarily the main cause. One of the problems Windows is facing is that, while supporting a lot of hardware is a good thing in general, it also supports all the crap hardware, crap drivers and crap ACPI implementations.
He has high speed connections with 350ms ping times to the server thats
half way around the world. Windows XP, at least, did not default to
an RWIN over 64k. He needs about 300K for that link, give or take,
depending on how fast the wires are. He can go into the registry (of
the XP client) and bump is RWIN to something larger than pingtime (in
seconds) * wirespeed (in byte/sec) ... example: 0.350 ping * 700K
byte/sec = ~250K, so use 300k or 400k for TCP Recieve Window Size)
From | Date | Subject | |
---|---|---|---|
Next Message | pasman pasmański | 2010-11-10 09:25:13 | Comments on tables |
Previous Message | Antonio Goméz Soto | 2010-11-10 07:32:11 | Re: Libpq is very slow on windows but fast on linux. |