Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id D9DD71DA4C1F for ; Tue, 17 Jan 2012 16:51:58 -0400 (AST) Received: from fmf.vgtu.lt ([158.129.206.146]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1RnG0X-0002rh-TA for pgsql-admin@postgresql.org; Tue, 17 Jan 2012 20:51:58 +0000 Received: from fmf.vtu.lt (localhost [127.0.0.1]) by fmf.vgtu.lt (Postfix) with ESMTP id D294010104; Tue, 17 Jan 2012 22:51:38 +0200 (EET) Received: from 77.240.249.53 (SquirrelMail authenticated user nso) by fmf.vtu.lt with HTTP; Tue, 17 Jan 2012 22:51:38 +0200 Message-ID: <17fee828df2a0dfa0f507b22051e6b15.squirrel@fmf.vtu.lt> In-Reply-To: References: <4F15517F0200002500044874@gw.wicourts.gov> <20244.1326820717@sss.pgh.pa.us> <4F155D480200002500044884@gw.wicourts.gov> <22686.1326828228@sss.pgh.pa.us> Date: Tue, 17 Jan 2012 22:51:38 +0200 Subject: Re: Establishing remote connections is slow From: "Lukas" To: pgsql-admin@postgresql.org Cc: =?utf-8?B?Ik1pbmRhdWdhcyDFvWFrxaFhdXNrYXMi?= Reply-To: Lukas@fmf.vtu.lt User-Agent: SquirrelMail/1.4.22 MIME-Version: 1.0 Content-Type: text/plain;charset=utf-8 X-Priority: 3 (Normal) Importance: Normal Content-Transfer-Encoding: quoted-printable X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201201/74 X-Sequence-Number: 38986 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 i= t will show you something strange.. -- Lukas UAB nSoft www.nsoft.lt > On Tue, Jan 17, 2012 at 7:23 PM, Tom Lane wrote: >> <..> =C2=A0Mindaugas, 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 >