From: Lukas <lukas@fmf.vgtu.lt>
To: pgsql-admin@postgresql.org
Subject: Re: Establishing remote connections is slow
Date: Tue, 17 Jan 2012 18:26:09 +0200
Message-ID: <504c05f026eb2ba48cdc2dcf4e8f255f.squirrel@fmf.vtu.lt> (raw)
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>
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
>
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.vgtu.lt
Subject: Re: Establishing remote connections is slow
In-Reply-To: <504c05f026eb2ba48cdc2dcf4e8f255f.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