Re: pg_connect takes 3.0 seconds

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Dmitri Girski <mitek17(at)gmail(dot)com>
Cc: Andy Colson <andy(at)squeakycode(dot)net>, pgsql-performance(at)postgresql(dot)org
Subject: Re: pg_connect takes 3.0 seconds
Date: 2010-01-06 04:50:47
Message-ID: 4B4416A7.1040808@postnewspapers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Matthew Wakeling 2010-01-06 10:45:20 Re: pg_connect takes 3.0 seconds
Previous Message Scott Marlowe 2010-01-06 04:39:40 Re: pg_connect takes 3.0 seconds