Re: Establishing remote connections is slow

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: Mindaugas Žakšauskas <mindas(at)gmail(dot)com>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Establishing remote connections is slow
Date: 2012-01-17 16:46:23
Message-ID: 4F15517F0200002500044874@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Mindaugas Žakšauskas<mindas(at)gmail(dot)com> wrote:

> The essence is that establishing remote connection takes anywhere
> from 10 to 30 seconds. Once connected, the queries are fast

The only time I've seen something similar, there was no reverse DNS
entry to go from IP address to host name. Adding that corrected the
issue. I would try that.

If that fixes it, the questions would be whether PostgreSQL is doing
an unnecessary reverse DNS lookup.

-Kevin

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2012-01-17 17:18:37 Re: Establishing remote connections is slow
Previous Message Lukas 2012-01-17 16:26:09 Re: Establishing remote connections is slow