From: | Rob Brown-Bayliss <r(dot)brown(dot)bayliss(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Libpq is very slow on windows but fast on linux. |
Date: | 2010-11-07 00:07:52 |
Message-ID: | AANLkTinxwtJ_z9qmdK8+8nt=bhQi4AeET3xnwFAJcqU8@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks, but no, it's using ip, and after the connection has been
established etc. the 3500ms it the total query time on windows vs
800ms on linux. Same server, so I think it is related to libpq
implementation on windows.
I also get the same results running XP in a virtualbox on a linux
machine, while the linux host machine is getting 800ms.
On Sun, Nov 7, 2010 at 12:59 PM, Joe Conway <mail(at)joeconway(dot)com> wrote:
> On 11/06/2010 04:54 PM, Rob Brown-Bayliss wrote:
>> Hi
>>
>> I have a problem with libpq on windows. Connecting to a db and running
>> a "select * from some_table;" is very slow.
>>
>> The table has only 1800 rows, 7 columns. No blobs etc.
>>
>> The query is taking around 3500ms, in linux it takes around 800ms.
>> (About 500ms is network time, the server is on the opposite side of
>> the world from my location.)
>>
>> The hardware is identical (dual boot)
>>
>> Why does this so long in windows? I tested in pqsl, and pgadmin to
>> rule out errors in the app code.
>>
>> Any advice or clues? I need the app to work on both platforms.
>
> Just a guess, but maybe DNS lookup time? Try using IP address instead of
> FQDN.
>
> HTH,
>
> Joe
>
> --
> Joe Conway
> credativ LLC: http://www.credativ.us
> Linux, PostgreSQL, and general Open Source
> Training, Service, Consulting, & 24x7 Support
>
>
--
--
Rob
From | Date | Subject | |
---|---|---|---|
Next Message | Rob Brown-Bayliss | 2010-11-07 00:12:33 | Re: Libpq is very slow on windows but fast on linux. |
Previous Message | John R Pierce | 2010-11-07 00:06:12 | Re: Libpq is very slow on windows but fast on linux. |