Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125])
	by mail.postgresql.org (Postfix) with ESMTP id 9F11F1DA4C1F
	for <pgsql-admin@postgresql.org>; Tue, 17 Jan 2012 12:26:30 -0400 (AST)
Received: from fmf.vgtu.lt ([158.129.206.146])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <lukas@fmf.vgtu.lt>) id 1RnBrd-0006k6-7K
	for pgsql-admin@postgresql.org; Tue, 17 Jan 2012 16:26:29 +0000
Received: from fmf.vtu.lt (localhost [127.0.0.1])
	by fmf.vgtu.lt (Postfix) with ESMTP id 9C63A10104
	for <pgsql-admin@postgresql.org>; Tue, 17 Jan 2012 18:26:09 +0200 (EET)
Received: from 77.240.249.53 (SquirrelMail authenticated user nso)
	by fmf.vtu.lt with HTTP; Tue, 17 Jan 2012 18:26:09 +0200
Message-ID: <504c05f026eb2ba48cdc2dcf4e8f255f.squirrel@fmf.vtu.lt>
In-Reply-To: 
 <CAKTEH83ncT6GZwWB=TRwxL8SYWYyJTtjjkcDm+7JMzPnCwCmvg@mail.gmail.com>
References: 
 <CAKTEH83nqC5NBZjWJ2ZAW8eBMWjW3N6G3RhbsWy68rMgf=MF1Q@mail.gmail.com>
	<15697.1326812982@sss.pgh.pa.us>
	<CAKTEH82c3hJxerDSSaC-9yK4yNrwPcV_z2pxfr9noBHrCPmUfQ@mail.gmail.com>
	<16644.1326814872@sss.pgh.pa.us>
	<CAKTEH83ncT6GZwWB=TRwxL8SYWYyJTtjjkcDm+7JMzPnCwCmvg@mail.gmail.com>
Date: Tue, 17 Jan 2012 18:26:09 +0200
Subject: Re: Establishing remote connections is slow
From: "Lukas" <lukas@fmf.vgtu.lt>
To: pgsql-admin@postgresql.org
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/79
X-Sequence-Number: 38991

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

> On Tue, Jan 17, 2012 at 3:41 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
>> Hm. =C2=A0AFAIR postgres doesn't know anything particular about multip=
ath
>> 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.
>
>> =C2=A0So I'm thinking this is a system-level issue. =C2=A0It still see=
ms like it
>> could be DNS
>> lookup related though. =C2=A0Do you have log_hostname turned on, and i=
f 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
>