Search Postgresql Archives

Re: Libpq is very slow on windows but fast on linux.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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)




--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux