From: Lukas <Lukas@fmf.vtu.lt>
To: pgsql-admin@postgresql.org
Cc: "Mindaugas Žakšauskas" <mindas@gmail.com>
Subject: Re: Establishing remote connections is slow
Date: Tue, 17 Jan 2012 22:51:38 +0200
Message-ID: <17fee828df2a0dfa0f507b22051e6b15.squirrel@fmf.vtu.lt> (raw)
In-Reply-To: <CAKTEH80OQPbFee7E_XCWqM87+wSpV-0AvM=cCo-c0KRMqwMB=A@mail.gmail.com>
References: <CAKTEH83nqC5NBZjWJ2ZAW8eBMWjW3N6G3RhbsWy68rMgf=MF1Q@mail.gmail.com>
<4F15517F0200002500044874@gw.wicourts.gov>
<20244.1326820717@sss.pgh.pa.us>
<4F155D480200002500044884@gw.wicourts.gov>
<22686.1326828228@sss.pgh.pa.us>
<CAKTEH80OQPbFee7E_XCWqM87+wSpV-0AvM=cCo-c0KRMqwMB=A@mail.gmail.com>
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
UAB nSoft
www.nsoft.lt
> On Tue, Jan 17, 2012 at 7:23 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> <..> Mindaugas, are you using SSL,
>> and if so can you turn it off and see whether things change?
>> (It should be safe to do so at least on the "localhost" connection,
>> even if you feel your network is insecure.)
>
> No, I am not using SSL; it is either disabled or the default setting
> is off anyway. This was one of the first things I have checked.
> Moreover, this would probably make it hard to explain why does it take
> no time to establish connections immediately after PostgreSQL restart
> and why it does it degrade later.
>
> To respond to previous emails - we tried doing DNS lookups against the
> client host and they took no time.
>
> Thanks for your ideas.
>
> 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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Lukas@fmf.vtu.lt, mindas@gmail.com
Subject: Re: Establishing remote connections is slow
In-Reply-To: <17fee828df2a0dfa0f507b22051e6b15.squirrel@fmf.vtu.lt>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox