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

From Dann Corbit
Subject Re: Libpq is very slow on windows but fast on linux.
Date
Msg-id 87F42982BF2B434F831FCEF4C45FC33E42078CA1@EXCHANGE.corporate.connx.com
Whole thread Raw
In response to Re: Libpq is very slow on windows but fast on linux.  (Rob Brown-Bayliss <r.brown.bayliss@gmail.com>)
Responses Re: Libpq is very slow on windows but fast on linux.  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
> -----Original Message-----
> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
> owner@postgresql.org] On Behalf Of Rob Brown-Bayliss
> Sent: Tuesday, November 09, 2010 8:20 PM
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Libpq is very slow on windows but fast on linux.
>
> 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.

Check your Nagle setting.
http://support.microsoft.com/kb/138831

See also:
http://apocryph.org/2006/07/08/achieving_maximum_tcp_performance_on_windows_xp_2k3/

P.S.
Iperf is really useful to see how well things are going as a diagnostic tool:
http://sourceforge.net/projects/iperf/files/


pgsql-general by date:

Previous
From: Rob Brown-Bayliss
Date:
Subject: Re: Libpq is very slow on windows but fast on linux.
Next
From: John R Pierce
Date:
Subject: Re: Libpq is very slow on windows but fast on linux.