Re: pg_connect takes 3.0 seconds - Mailing list pgsql-performance

From Craig Ringer
Subject Re: pg_connect takes 3.0 seconds
Date
Msg-id 4B4416A7.1040808@postnewspapers.com.au
Whole thread Raw
In response to Re: pg_connect takes 3.0 seconds  (Dmitri Girski <mitek17@gmail.com>)
Responses Re: pg_connect takes 3.0 seconds  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-performance
Dmitri Girski wrote:
> Hi Andy,
>
> I tried  2 connections strings:
> - server name (DB1),  which is listed in all machines hosts files.
> - ip address.
>
> There is no difference in both methods, still I have 5-7 pg_connects which
> last around 3 seconds.

Don't rule out reverse DNS issues (such as a negative cache entry
expiring and being re-checked), packet loss, nss issues on the server
related to NIS, LDAP etc user directories, and so on.

Wireshark is your friend.

--
Craig Ringer

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: pg_connect takes 3.0 seconds
Next
From: Matthew Wakeling
Date:
Subject: Re: pg_connect takes 3.0 seconds