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

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: Libpq is very slow on windows but fast on linux.
Дата
Msg-id 4CDA4BD2.3000902@hogranch.com
обсуждение исходный текст
Ответ на Re: Libpq is very slow on windows but fast on linux.  (Alban Hertroys <dalroi@solfertje.student.utwente.nl>)
Список 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 по дате отправления:

Предыдущее
От: Antonio Goméz Soto
Дата:
Сообщение: Re: Libpq is very slow on windows but fast on linux.
Следующее
От: pasman pasmański
Дата:
Сообщение: Comments on tables