Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 3673B63271E
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Tue,  5 Jan 2010 11:03:27 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 44396-04
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Tue,  5 Jan 2010 15:03:16 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from marajade.localdomain (vcs5.camavision.com [63.228.164.252])
	by mail.postgresql.org (Postfix) with ESMTP id C08176326B2
	for <pgsql-performance@postgresql.org>;
	Tue,  5 Jan 2010 11:03:16 -0400 (AST)
Received: from [192.168.10.85] (unknown [192.168.10.85])
	(Authenticated sender: andy)
	by marajade.localdomain (Postfix) with ESMTPA id E6323A01B4;
	Tue,  5 Jan 2010 09:03:14 -0600 (CST)
Message-ID: <4B4354B0.8030400@squeakycode.net>
Date: Tue, 05 Jan 2010 09:03:12 -0600
From: Andy Colson <andy@squeakycode.net>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
	rv:1.9.1.5) Gecko/20091204 Thunderbird/3.0
MIME-Version: 1.0
To: Dmitri Girski <mitek17@gmail.com>, pgsql-performance@postgresql.org
Subject: Re: pg_connect takes 3.0 seconds
References: <daed64561001041812s602a3098l686f630d6448835f@mail.gmail.com>
In-Reply-To: <daed64561001041812s602a3098l686f630d6448835f@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=3.003 tagged_above=-10 required=5
	tests=BAYES_40=-0.185, FH_DATE_PAST_20XX=3.188
X-Spam-Level: ***
X-Archive-Number: 201001/43
X-Sequence-Number: 36923

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