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

From Dmitri Girski
Subject Re: pg_connect takes 3.0 seconds
Date
Msg-id daed64561001051925k26682e50ue1792e7032a75bd5@mail.gmail.com
Whole thread Raw
In response to Re: pg_connect takes 3.0 seconds  (Andy Colson <andy@squeakycode.net>)
Responses Re: pg_connect takes 3.0 seconds
List pgsql-performance
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.

Cheers,
Dmitri.

On Wed, Jan 6, 2010 at 2:03 AM, Andy Colson <andy@squeakycode.net> wrote:
On 1/4/2010 8:12 PM, Dmitri Girski wrote:
Hi everybody,

I am running a PostgreSQL server 8.3.5 with a pretty much standard config.

The web application server which runs Apache 1.3/PHP2.9  has an
intermittent problem:
pg_connect takes exactly 3.0 seconds. The usual connection time is 0.0045.
The long request happens at approximate rate 1:100.

I turned on logs on postgres server side, and there is
nothing suspicious for me there. When a connection request comes, it is
being served without any delay.

Could anyone point me to the direction in which I should investigate
this problem further?
Thank you in advance!


PS The hardware is: Dell SC1435/4Gb/2x2.0GHz/Gentoo Linux.
The database & web servers are in the 2 local subnets.


Dmitri.


How do you have the connect string?  With an IP or a name?  Maybe its a DNS lookup timeout?  You could switch to IP or drop the name in the hosts file and see if that makes a difference.

-Andy



--
@Gmail

pgsql-performance by date:

Previous
From: Robert Haas
Date:
Subject: Re: query looping?
Next
From: Dmitri Girski
Date:
Subject: Re: pg_connect takes 3.0 seconds