From: | Valentin Gjorgjioski <tinodj(at)mt(dot)net(dot)mk> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: remote connection problem |
Date: | 2012-05-17 10:46:45 |
Message-ID: | 4FB4D715.3090800@mt.net.mk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On 17.05.2012 11:27 Michael Wood wrote:
> Hi
>
> On 17 May 2012 09:28, Ilija Vidoevski<ilija(at)fructal(dot)com(dot)mk> wrote:
>> Thank's Michael.
>>
>> How can I be so blind. Connection is made.
>
> Good.
>
>> But speed through LAN is disaster.
>> On the PC where postgresql server is installed, postgre is little slower
>> then MS SqlSerever 2008 r2 express (same tables, same indexeses, same
>> query).
>>
>> But when I run app on client PC retrieving data from server is very, very
>> slow. On server PC report finish for 2-3 sec, but on client PC about 1 min.
>>
>> On the server is also installed MS SqlSerever 2008 r2 express, and there is
>> not great differences in speed to get data (from server or client PC). From
>> server PC 1-2 sec and from client PC 2-4 sec.
>
> Perhaps someone on the list will have an idea of why this might be.
> I've copied the list in my reply.
Probably has something with dns resolution of host name. Try to disable
that in postgres, or fix the dns on the server that resolves the client
name/ip.
From | Date | Subject | |
---|---|---|---|
Next Message | lindsay.braine | 2012-05-17 17:33:37 | PG_DUMP producing incorrect SQL |
Previous Message | Michael Wood | 2012-05-17 09:27:36 | Re: remote connection problem |