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

From: Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl>
To: Rob Brown-Bayliss <r(dot)brown(dot)bayliss(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Libpq is very slow on windows but fast on linux.
Date: 2010-11-10 07:22:24
Message-ID: A9318007-33B4-400B-BB5E-742F10DEC5BC@solfertje.student.utwente.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 10 Nov 2010, at 5:19, Rob Brown-Bayliss wrote:

> Further testing shows it is windows networking causing the issue.
> Copying files to and from the server is 5 to 6 times slower on a
> Windows client compared to the Linux client.
>
> The issue is not specific to libpq.

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.

Alban Hertroys

--
Screwing up is an excellent way to attach something to the ceiling.

!DSPAM:737,4cda484310265265216060!

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Antonio Goméz Soto 2010-11-10 07:32:11 Re: Libpq is very slow on windows but fast on linux.
Previous Message John R Pierce 2010-11-10 06:17:34 Re: Libpq is very slow on windows but fast on linux.