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

From: Dann Corbit <DCorbit(at)connx(dot)com>
To: 'Rob Brown-Bayliss' <r(dot)brown(dot)bayliss(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Libpq is very slow on windows but fast on linux.
Date: 2010-11-10 05:53:21
Message-ID: 87F42982BF2B434F831FCEF4C45FC33E42078CA1@EXCHANGE.corporate.connx.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-
> owner(at)postgresql(dot)org] On Behalf Of Rob Brown-Bayliss
> Sent: Tuesday, November 09, 2010 8:20 PM
> To: pgsql-general(at)postgresql(dot)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/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2010-11-10 06:17:34 Re: Libpq is very slow on windows but fast on linux.
Previous Message Rob Brown-Bayliss 2010-11-10 04:19:59 Re: Libpq is very slow on windows but fast on linux.