Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 0839E63237E
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Mon,  4 Jan 2010 22:13:26 -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 24104-09
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Tue,  5 Jan 2010 02:13:15 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-px0-f194.google.com (mail-px0-f194.google.com
	[209.85.216.194])
	by mail.postgresql.org (Postfix) with ESMTP id 278DC6322B5
	for <pgsql-performance@postgresql.org>;
	Mon,  4 Jan 2010 22:13:14 -0400 (AST)
Received: by pxi32 with SMTP id 32so10551548pxi.15
	for <pgsql-performance@postgresql.org>;
	Mon, 04 Jan 2010 18:13:13 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:sender:received:from:date
	:x-google-sender-auth:message-id:subject:to:content-type;
	bh=Mg+aYS3XlKdXcgYatuGYMAu6eja8lOdgPfJCBd9pqco=;
	b=pTp0OT4pUx562yOJ3W4VzyFO9ULxtWai6XNX3dUDNuIVlCR2vm/uCS8cPkvngCIKHN
	go6DIJXM1Q2q2WjieccJzZPnP5cYNl67WXpH06ZHvhGmV2mPaP394qx/iz7tAQ/a5S6H
	we/hV5k1SW7PQzXWcK0/5/sfRyARv4VdWPEe0=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:sender:from:date:x-google-sender-auth:message-id
	:subject:to:content-type;
	b=rRM/vfBAOlu1W9nO3a9Xk2MAWzZTOhnEKpXIYRVxmLMaUJXlgxplGKaSgSgupyvry8
	orVtjnUW/BLCHfJfy4ctYRZnRFDVdqrgF44bGHg0gA4XIOAikVhpY+o4z1G437B5oCik
	6RDbJ1Tq7rdowXvWGtd46stYfk70itj7JkhOY=
MIME-Version: 1.0
Received: by 10.114.214.25 with SMTP id m25mr844614wag.56.1262657593119; Mon,
	04 Jan 2010 18:13:13 -0800 (PST)
From: Dmitri Girski <mitek17@gmail.com>
Date: Tue, 5 Jan 2010 13:12:53 +1100
X-Google-Sender-Auth: 3363369ea176c9dc
Message-ID: <daed64561001041812s602a3098l686f630d6448835f@mail.gmail.com>
Subject: pg_connect takes 3.0 seconds
To: pgsql-performance@postgresql.org
Content-Type: multipart/alternative; boundary=0016e64aef9e4f94f4047c61619c
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=2.449 tagged_above=-10 required=5
	tests=BAYES_20=-0.74, FH_DATE_PAST_20XX=3.188, HTML_MESSAGE=0.001
X-Spam-Level: **
X-Archive-Number: 201001/35
X-Sequence-Number: 36915

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

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.

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

<font color=3D"#000099"><span class=3D"Apple-style-span" style=3D"color: rg=
b(0, 0, 0); font-family: arial, sans-serif; font-size: 13px; border-collaps=
e: collapse; "><font color=3D"#000099">Hi everybody,</font><div><span style=
=3D"color: rgb(0, 0, 153); "><br>

</span></div><div><span style=3D"color: rgb(0, 0, 153); ">I am running a Po=
stgreSQL server 8.3.5 with a pretty much standard config.</span></div><div>=
<span style=3D"color: rgb(0, 0, 153); "><br></span></div><div><span style=
=3D"color: rgb(0, 0, 153); ">The web application server which runs Apache 1=
.3/PHP2.9 =A0has an intermittent problem:</span></div>

<div><span style=3D"color: rgb(0, 0, 153); ">pg_connect takes exactly 3.0 s=
econds. The usual connection time is 0.0045.</span></div><div><span style=
=3D"color: rgb(0, 0, 153); ">The long request happens at approximate rate 1=
:100.</span></div>

<div><font color=3D"#000099"><br></font></div><div><font color=3D"#000099">=
I turned on logs on postgres server side, and there is nothing=A0suspicious=
=A0for me there. When a connection request comes, it is being served withou=
t any delay.=A0</font></div>

<div><font color=3D"#000099"><br></font></div><div><font color=3D"#000099">=
Could anyone point me to the direction in which I should investigate this p=
roblem further?</font></div><div><font color=3D"#000099">Thank you in advan=
ce!</font></div>

<div><font color=3D"#000099"><br></font></div><div><font color=3D"#000099">=
<br></font></div><div><font color=3D"#000099">PS The hardware is: Dell=A0SC=
1435/4Gb/2x2.0GHz/Gentoo Linux.</font></div><div><font color=3D"#000099">Th=
e database &amp; web servers are in the 2 local subnets.=A0</font></div>

<div><font color=3D"#000099"><br></font></div><div><font color=3D"#000099">=
<br></font></div><div><font color=3D"#000099">Dmitri.</font></div></span></=
font><br>

--0016e64aef9e4f94f4047c61619c--