Re: Establishing remote connections is slow - Mailing list pgsql-admin

From Lukas
Subject Re: Establishing remote connections is slow
Date
Msg-id 504c05f026eb2ba48cdc2dcf4e8f255f.squirrel@fmf.vtu.lt
Whole thread Raw
In response to Re: Establishing remote connections is slow  (Mindaugas Žakšauskas <mindas@gmail.com>)
List pgsql-admin
Hi,

 if you try to connect with pssql over your IP and it works slow, it is
possible that you have problem with reverse dns lookup. To check, try to
run nslookup tool, and enter your IP address (on the same machine) - if
it is problem with dns, it will resolve it slow as well..
 Also, try to check traceroute/trapath utilities with the same IP maybe it
will show you something strange..


Lukas

> On Tue, Jan 17, 2012 at 3:41 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
>> Hm.  AFAIR postgres doesn't know anything particular about multipath
>> interfaces --- it just listens where you tell it to.
>
> I was thinking the same, but PostgreSQL is the "first line to contact"
> and I somehow need to obtain a proof that this is indeed a
> system-level issue. My simple netcat experiments seem to suggest the
> opposite.
>
>>  So I'm thinking this is a system-level issue.  It still seems like it
>> could be DNS
>> lookup related though.  Do you have log_hostname turned on, and if so
>> does turning it off make a difference?
>
> log_hostname is turned off.
>
> Thanks for your help!
>
> Regards,
> Mindaugas
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>



pgsql-admin by date:

Previous
From: Walter Hurry
Date:
Subject: Re: apt installation postgresql 8.3
Next
From: "Kevin Grittner"
Date:
Subject: Re: apt installation postgresql 8.3