Re: Libpq is very slow on windows but fast on linux. - Mailing list pgsql-general

From John R Pierce
Subject Re: Libpq is very slow on windows but fast on linux.
Date
Msg-id 4CDA4BD2.3000902@hogranch.com
Whole thread Raw
In response to Re: Libpq is very slow on windows but fast on linux.  (Alban Hertroys <dalroi@solfertje.student.utwente.nl>)
List 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
alsosupports 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)




pgsql-general by date:

Previous
From: Antonio Goméz Soto
Date:
Subject: Re: Libpq is very slow on windows but fast on linux.
Next
From: pasman pasmański
Date:
Subject: Comments on tables