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

From John R Pierce
Subject Re: Libpq is very slow on windows but fast on linux.
Date
Msg-id 4CD6204C.1010304@hogranch.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>)
List pgsql-general
On 11/06/10 6:27 PM, Rob Brown-Bayliss wrote:
> On Sun, Nov 7, 2010 at 1:06 PM, John R Pierce<pierce@hogranch.com>  wrote:
>
>> how about if you do something like, SELECT * FROM SOME_TABLE INTO
>> SOME_OTHER_TABLE;  which doesn't involve returning data?
> In this case the times are as close to equal as to make no difference,
> within a couple of ms of each other.  About 300ms each.

k, so its definitely the data transmission thats hurting you.

you said downloads were fine.  does that include downloads from this
specific server ?



pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Libpq is very slow on windows but fast on linux.
Next
From: Andreas
Date:
Subject: Need magic to clean strings from unconvertible UTF8