Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 3187E6324C4
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Tue,  5 Jan 2010 23:30:01 -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 62912-02
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Wed,  6 Jan 2010 03:29:50 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-pw0-f44.google.com (mail-pw0-f44.google.com
	[209.85.160.44])
	by mail.postgresql.org (Postfix) with ESMTP id 56EF1632433
	for <pgsql-performance@postgresql.org>;
	Tue,  5 Jan 2010 23:29:50 -0400 (AST)
Received: by pwi15 with SMTP id 15so11690046pwi.3
	for <pgsql-performance@postgresql.org>;
	Tue, 05 Jan 2010 19:29:48 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:sender:received:in-reply-to
	:references:from:date:x-google-sender-auth:message-id:subject:to:cc
	:content-type; bh=WclkT0vAK7IKA1/6qn1A8ekcrl8vuaPr1ewIpEUoFKk=;
	b=DZLruaTGiSdqM1t/7hchJp8L0UR/qDIYhlz6Cxfh8XcRqwhe/pS3cc/E0aPZWnN0Vg
	c6LJd0VqFEE11srL9sOoxQWdha1FWjSnC8TQ6akiCIOY+aCFRB9Pez59lV0cKmbLEZW2
	H67QsAj/V3pRrJcbmtCB9SAYgLRnMqGMoLRqI=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:sender:in-reply-to:references:from:date
	:x-google-sender-auth:message-id:subject:to:cc:content-type;
	b=vkSA/NAHu5toyg87yhJLve9g6bBzoNDAOZRIg95h5Q9S3oBNGwKpPS7xJZipbo08ag
	crgUXc8kmKTKsJKvfg3j1YdVGmoxZxU5bhoygqFvbeKGQbL8wdstNIxpZ99HZ0UEcYnO
	Exwlj+8UofOdyJdpnm076+IaSYpAhSHWo9VRg=
MIME-Version: 1.0
Received: by 10.115.114.9 with SMTP id r9mr15599691wam.19.1262748588174; Tue,
	05 Jan 2010 19:29:48 -0800 (PST)
In-Reply-To: <4B4354B0.8030400@squeakycode.net>
References: <daed64561001041812s602a3098l686f630d6448835f@mail.gmail.com>
	<4B4354B0.8030400@squeakycode.net>
From: Dmitri Girski <mitek17@gmail.com>
Date: Wed, 6 Jan 2010 14:29:28 +1100
X-Google-Sender-Auth: 965cca4de90de79b
Message-ID: <daed64561001051929k1ea5012bib2aa9159787d7f75@mail.gmail.com>
Subject: Re: pg_connect takes 3.0 seconds
To: Andy Colson <andy@squeakycode.net>
Cc: pgsql-performance@postgresql.org
Content-Type: multipart/alternative; boundary=0016e64b99f409ef12047c769173
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.59 tagged_above=-10 required=5
	tests=BAYES_00=-2.599, FH_DATE_PAST_20XX=3.188, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201001/54
X-Sequence-Number: 36934

--0016e64b99f409ef12047c769173
Content-Type: text/plain; charset=ISO-8859-1

Thank you for reply , Andy!

I tried both cases: server name which is listed in hosts file and ip address
( 192.168.2.2) - no difference so far.

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

--0016e64b99f409ef12047c769173
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<font color=3D"#000099">Thank you for reply , Andy!</font><div><font class=
=3D"Apple-style-span" color=3D"#000099"><br></font></div><div><font color=
=3D"#000099">I tried both cases: server name which is listed in hosts file =
and ip address ( 192.168.2.2) - no difference so far.</font></div>

<div><font class=3D"Apple-style-span" color=3D"#000099"><br></font></div><d=
iv><font color=3D"#000099">Cheers,</font></div><div><font color=3D"#000099"=
>Dmitri.<br></font><br><div class=3D"gmail_quote">On Wed, Jan 6, 2010 at 2:=
03 AM, Andy Colson <span dir=3D"ltr">&lt;<a href=3D"mailto:andy@squeakycode=
.net">andy@squeakycode.net</a>&gt;</span> wrote:<br>

<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex;"><div><div></div><div class=3D"h5">On 1/4/20=
10 8:12 PM, Dmitri Girski wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex">
Hi everybody,<br>
<br>
I am running a PostgreSQL server 8.3.5 with a pretty much standard config.<=
br>
<br>
The web application server which runs Apache 1.3/PHP2.9 =A0has an<br>
intermittent problem:<br>
pg_connect takes exactly 3.0 seconds. The usual connection time is 0.0045.<=
br>
The long request happens at approximate rate 1:100.<br>
<br>
I turned on logs on postgres server side, and there is<br>
nothing suspicious for me there. When a connection request comes, it is<br>
being served without any delay.<br>
<br>
Could anyone point me to the direction in which I should investigate<br>
this problem further?<br>
Thank you in advance!<br>
<br>
<br>
PS The hardware is: Dell SC1435/4Gb/2x2.0GHz/Gentoo Linux.<br>
The database &amp; web servers are in the 2 local subnets.<br>
<br>
<br>
Dmitri.<br>
<br>
</blockquote>
<br></div></div>
How do you have the connect string? =A0With an IP or a name? =A0Maybe its a=
 DNS lookup timeout? =A0You could switch to IP or drop the name in the host=
s file and see if that makes a difference.<br><font color=3D"#888888">
<br>
-Andy<br>
</font></blockquote></div><br><br clear=3D"all"><br>-- <br>@Gmail<br>
</div>

--0016e64b99f409ef12047c769173--