From arindam.hore@in.v2solutions.com Fri Jan  21 10:52:18 2011
Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 817EF1337B84
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Fri, 21 Jan 2011 06:52:18 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 16087-01 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Fri, 21 Jan 2011 10:52:11 +0000 (UTC)
X-Greylist: delayed 00:05:39.551923 by SQLgrey-1.7.6
Received: from webmail.in.v2solutions.com (unknown [122.182.0.74])
	by mail.postgresql.org (Postfix) with ESMTP id D6F3F1337B81
	for <pgsql-sql@postgresql.org>; Fri, 21 Jan 2011 06:52:09 -0400 (AST)
Received: from mbx.in.v2solutions.com ([::1]) by casnhub.in.v2solutions.com
	([::1]) with mapi; Fri, 21 Jan 2011 16:15:59 +0530
From: Arindam Hore <arindam.hore@in.v2solutions.com>
To: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
Subject: Issue with postgres connectivity
Thread-Topic: Issue with postgres connectivity
Thread-Index: Acu5WFcQ5DXNVngYSxmM3lizgKWW4A==
Date: Fri, 21 Jan 2011 10:45:37 +0000
Message-ID: <2C43C4BE6357654AB4E898C9E9EBA83E32BC2849@mbx.in.v2solutions.com>
Accept-Language: en-US
Content-Language: en-US
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Content-Type: multipart/alternative;
	boundary="_000_2C43C4BE6357654AB4E898C9E9EBA83E32BC2849mbxinv2solution_"
MIME-Version: 1.0
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.106 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
	HTML_MESSAGE=0.001, RDNS_NONE=0.793
X-Spam-Level: 
X-Archive-Number: 201101/56
X-Sequence-Number: 35003

--_000_2C43C4BE6357654AB4E898C9E9EBA83E32BC2849mbxinv2solution_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hello All,

I am facing a big problem in postgres connectivity using php application. I=
t is taking almost 10 sec for connection establishment. All my applications=
 were working perfectly 2 days before. Yesterday just it started giving pro=
blem. Using pg-admin also it is taking time to connect as well as same with=
 opening server status window or with sql query window.

Postgres is installed in linux environment. Don't know whether is it due to=
 some virus or something else.

Please provide me with some guidelines. Ask me any queries.

Thanks,
Arindam

V2Solutions
A New Vision to Solutions
India: +91-22-66733201 Ext:- 676
US : 1-408-454-6051 Ext:- 263
http://www.v2solutions.com<http://www.v2solutions.com/>
TZ : +5:30 GMT

This email and any files transmitted with it are confidential and intended =
solely for the use of the individual or entity to whom they are addressed. =
If you have received this email in error please notify the system manager. =
This message contains confidential information and is intended only for the=
 individual named. If you are not the named addressee you should not dissem=
inate, distribute or copy this e-mail.

--_000_2C43C4BE6357654AB4E898C9E9EBA83E32BC2849mbxinv2solution_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=
>
<meta name=3D"Generator" content=3D"Microsoft Word 12 (filtered medium)">
<style>
<!--
 /* Font Definitions */
 @font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:purple;
	text-decoration:underline;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Calibri","sans-serif";
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;}
@page Section1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
	{page:Section1;}
-->
</style><!--[if gte mso 9]><xml>
 <o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
 <o:shapelayout v:ext=3D"edit">
  <o:idmap v:ext=3D"edit" data=3D"1" />
 </o:shapelayout></xml><![endif]-->
</head>
<body lang=3D"EN-US" link=3D"blue" vlink=3D"purple">
<div class=3D"Section1">
<p class=3D"MsoNormal">Hello All,<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">I am facing a big problem in postgres connectivity u=
sing php application. It is taking almost 10 sec for connection establishme=
nt. All my applications were working perfectly 2 days before. Yesterday jus=
t it started giving problem. Using
 pg-admin also it is taking time to connect as well as same with opening se=
rver status window or with sql query window.<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">Postgres is installed in linux environment. Don&#821=
7;t know whether is it due to some virus or something else.<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">Please provide me with some guidelines. Ask me any q=
ueries.<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal"><span style=3D"font-size:10.0pt;font-family:&quot;Ar=
ial&quot;,&quot;sans-serif&quot;">Thanks,<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:10.0pt;font-family:&quot;Ar=
ial&quot;,&quot;sans-serif&quot;">Arindam<o:p></o:p></span></p>
<p class=3D"MsoNormal"><b><span style=3D"font-size:10.0pt;font-family:&quot=
;Arial&quot;,&quot;sans-serif&quot;"><o:p>&nbsp;</o:p></span></b></p>
<p class=3D"MsoNormal"><b><i><span style=3D"font-size:10.0pt;font-family:&q=
uot;Arial&quot;,&quot;sans-serif&quot;">V2Solutions<br>
</span></i></b><i><span style=3D"font-size:10.0pt;font-family:&quot;Arial&q=
uot;,&quot;sans-serif&quot;">A New Vision to Solutions</span></i><i><span s=
tyle=3D"font-size:10.0pt;font-family:
&quot;Courier New&quot;"><br>
</span></i><i><span style=3D"font-size:10.0pt;font-family:&quot;Arial&quot;=
,&quot;sans-serif&quot;">India: &#43;91-22-66733201 Ext:- 676<br>
US : 1-408-454-6051 Ext:- 263<br>
</span></i><i><a href=3D"http://www.v2solutions.com/"><span style=3D"font-s=
ize:
10.0pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;;color:blue">htt=
p://www.v2solutions.com</span></a><br>
</i><i><span style=3D"font-size:10.0pt;font-family:&quot;Arial&quot;,&quot;=
sans-serif&quot;">TZ : &#43;5:30 GMT</span></i><i><o:p></o:p></i></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
</div>
This email and any files transmitted with it are confidential and intended =
solely for the use of the individual or entity to whom they are addressed. =
If you have received this email in error please notify the system manager. =
This message contains confidential
 information and is intended only for the individual named. If you are not =
the named addressee you should not disseminate, distribute or copy this e-m=
ail.
</body>
</html>

--_000_2C43C4BE6357654AB4E898C9E9EBA83E32BC2849mbxinv2solution_--



From reinoud.v@n.leeuwen.net Fri Jan  21 11:05:08 2011
Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id B489C1337B81
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Fri, 21 Jan 2011 07:05:08 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 16700-10 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Fri, 21 Jan 2011 11:05:01 +0000 (UTC)
X-Greylist: delayed 00:07:26.868328 by SQLgrey-1.7.6
Received: from smtp-vbr13.xs4all.nl (smtp-vbr13.xs4all.nl [194.109.24.33])
	by mail.postgresql.org (Postfix) with ESMTP id B25311337B83
	for <pgsql-sql@postgresql.org>; Fri, 21 Jan 2011 07:05:00 -0400 (AST)
Received: from spoetnik.xs4all.nl (spoetnik.xs4all.nl [82.95.228.65])
	by smtp-vbr13.xs4all.nl (8.13.8/8.13.8) with ESMTP id p0LAvSnQ065493
	for <pgsql-sql@postgresql.org>; Fri, 21 Jan 2011 11:57:33 +0100 (CET)
	(envelope-from reinoud.v@n.leeuwen.net)
Received: by spoetnik.xs4all.nl (Postfix, from userid 1000)
	id 9C6CB1CC5C; Fri, 21 Jan 2011 11:57:28 +0100 (CET)
Date: Fri, 21 Jan 2011 11:57:28 +0100
From: Reinoud van Leeuwen <reinoud.v@n.leeuwen.net>
To: pgsql-sql@postgresql.org
Subject: Re: Issue with postgres connectivity
Message-ID: <20110121105728.GJ80182@spoetnik.xs4all.nl>
Mail-Followup-To: pgsql-sql@postgresql.org
References: <2C43C4BE6357654AB4E898C9E9EBA83E32BC2849@mbx.in.v2solutions.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <2C43C4BE6357654AB4E898C9E9EBA83E32BC2849@mbx.in.v2solutions.com>
User-Agent: Mutt/1.5.13 (2006-08-11)
X-Virus-Scanned: by XS4ALL Virus Scanner
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
	RCVD_IN_DNSWL_NONE=-0.0001
X-Spam-Level: 
X-Archive-Number: 201101/57
X-Sequence-Number: 35004

On Fri, Jan 21, 2011 at 10:45:37AM +0000, Arindam Hore wrote:
> Hello All,
> 
> I am facing a big problem in postgres connectivity using php application. It is taking almost 10 sec for connection establishment. All my applications were working perfectly 2 days before. Yesterday just it started giving problem. Using pg-admin also it is taking time to connect as well as same with opening server status window or with sql query window.
> 
> Postgres is installed in linux environment. Don't know whether is it due to some virus or something else.
> 
> Please provide me with some guidelines. Ask me any queries.

this smells like DNS resolving...

Reinoud

-- 
__________________________________________________
"Nothing is as subjective as reality"
Reinoud van Leeuwen    reinoud.v@n.leeuwen.net
http://reinoud.van.leeuwen.net kvk 27320762
__________________________________________________



From arindam.hore@in.v2solutions.com Fri Jan  21 11:17:58 2011
Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id E7D851337B83
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Fri, 21 Jan 2011 07:17:58 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 66770-06 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Fri, 21 Jan 2011 11:17:51 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from webmail.in.v2solutions.com (unknown [122.182.0.74])
	by mail.postgresql.org (Postfix) with ESMTP id EAED61337B84
	for <pgsql-sql@postgresql.org>; Fri, 21 Jan 2011 07:17:50 -0400 (AST)
Received: from mbx.in.v2solutions.com ([::1]) by casnhub.in.v2solutions.com
	([::1]) with mapi; Fri, 21 Jan 2011 16:47:26 +0530
From: Arindam Hore <arindam.hore@in.v2solutions.com>
To: Reinoud van Leeuwen <reinoud.v@n.leeuwen.net>, "pgsql-sql@postgresql.org"
	<pgsql-sql@postgresql.org>
Subject: Re: Issue with postgres connectivity
Thread-Topic: [SQL] Issue with postgres connectivity
Thread-Index: AQHLuVspcTEDykBfXkqhZPwpCw5z4ZPbRqpQ
Date: Fri, 21 Jan 2011 11:17:25 +0000
Message-ID: <2C43C4BE6357654AB4E898C9E9EBA83E32BC2867@mbx.in.v2solutions.com>
References: <2C43C4BE6357654AB4E898C9E9EBA83E32BC2849@mbx.in.v2solutions.com>
	<20110121105728.GJ80182@spoetnik.xs4all.nl>
In-Reply-To: <20110121105728.GJ80182@spoetnik.xs4all.nl>
Accept-Language: en-US
Content-Language: en-US
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.107 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
	RDNS_NONE=0.793
X-Spam-Level: 
X-Archive-Number: 201101/58
X-Sequence-Number: 35005

Thanks Reinoud for quick reply. How can I test it? Is there any way?

-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org=
] On Behalf Of Reinoud van Leeuwen
Sent: Friday, January 21, 2011 4:27 PM
To: pgsql-sql@postgresql.org
Subject: Re: [SQL] Issue with postgres connectivity

On Fri, Jan 21, 2011 at 10:45:37AM +0000, Arindam Hore wrote:
> Hello All,
>
> I am facing a big problem in postgres connectivity using php application.=
 It is taking almost 10 sec for connection establishment. All my applicatio=
ns were working perfectly 2 days before. Yesterday just it started giving p=
roblem. Using pg-admin also it is taking time to connect as well as same wi=
th opening server status window or with sql query window.
>
> Postgres is installed in linux environment. Don't know whether is it due =
to some virus or something else.
>
> Please provide me with some guidelines. Ask me any queries.

this smells like DNS resolving...

Reinoud

--
__________________________________________________
"Nothing is as subjective as reality"
Reinoud van Leeuwen    reinoud.v@n.leeuwen.net
http://reinoud.van.leeuwen.net kvk 27320762
__________________________________________________

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
This email and any files transmitted with it are confidential and intended =
solely for the use of the individual or entity to whom they are addressed. =
If you have received this email in error please notify the system manager. =
This message contains confidential information and is intended only for the=
 individual named. If you are not the named addressee you should not dissem=
inate, distribute or copy this e-mail.



From arindam.hore@in.v2solutions.com Fri Jan  21 11:44:17 2011
Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id D97FA1337990
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Fri, 21 Jan 2011 07:44:17 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 44336-03 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Fri, 21 Jan 2011 11:44:12 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from webmail.in.v2solutions.com (unknown [122.182.0.74])
	by mail.postgresql.org (Postfix) with ESMTP id BEFB81336B42
	for <pgsql-sql@postgresql.org>; Fri, 21 Jan 2011 07:44:09 -0400 (AST)
Received: from mbx.in.v2solutions.com ([::1]) by casnhub.in.v2solutions.com
	([::1]) with mapi; Fri, 21 Jan 2011 17:13:48 +0530
From: Arindam Hore <arindam.hore@in.v2solutions.com>
To: Reinoud van Leeuwen <reinoud.v@n.leeuwen.net>, "pgsql-sql@postgresql.org"
	<pgsql-sql@postgresql.org>
Subject: Re: Issue with postgres connectivity
Thread-Topic: [SQL] Issue with postgres connectivity
Thread-Index: AQHLuVspcTEDykBfXkqhZPwpCw5z4ZPbTePQ
Date: Fri, 21 Jan 2011 11:43:49 +0000
Message-ID: <2C43C4BE6357654AB4E898C9E9EBA83E32BC287B@mbx.in.v2solutions.com>
References: <2C43C4BE6357654AB4E898C9E9EBA83E32BC2849@mbx.in.v2solutions.com>
	<20110121105728.GJ80182@spoetnik.xs4all.nl>
In-Reply-To: <20110121105728.GJ80182@spoetnik.xs4all.nl>
Accept-Language: en-US
Content-Language: en-US
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.107 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
	RDNS_NONE=0.793
X-Spam-Level: 
X-Archive-Number: 201101/59
X-Sequence-Number: 35006

We are accessing database using ip address.

-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org=
] On Behalf Of Reinoud van Leeuwen
Sent: Friday, January 21, 2011 4:27 PM
To: pgsql-sql@postgresql.org
Subject: Re: [SQL] Issue with postgres connectivity

On Fri, Jan 21, 2011 at 10:45:37AM +0000, Arindam Hore wrote:
> Hello All,
>
> I am facing a big problem in postgres connectivity using php application.=
 It is taking almost 10 sec for connection establishment. All my applicatio=
ns were working perfectly 2 days before. Yesterday just it started giving p=
roblem. Using pg-admin also it is taking time to connect as well as same wi=
th opening server status window or with sql query window.
>
> Postgres is installed in linux environment. Don't know whether is it due =
to some virus or something else.
>
> Please provide me with some guidelines. Ask me any queries.

this smells like DNS resolving...

Reinoud

--
__________________________________________________
"Nothing is as subjective as reality"
Reinoud van Leeuwen    reinoud.v@n.leeuwen.net
http://reinoud.van.leeuwen.net kvk 27320762
__________________________________________________

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
This email and any files transmitted with it are confidential and intended =
solely for the use of the individual or entity to whom they are addressed. =
If you have received this email in error please notify the system manager. =
This message contains confidential information and is intended only for the=
 individual named. If you are not the named addressee you should not dissem=
inate, distribute or copy this e-mail.



From erouse@comsquared.com Fri Jan  21 15:04:59 2011
Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id 8E0B41337990
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Fri, 21 Jan 2011 11:04:59 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 63795-03 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Fri, 21 Jan 2011 15:04:52 +0000 (UTC)
X-Greylist: delayed 00:17:17.978082 by SQLgrey-1.7.6
Received: from smtp.comsquared.com (smtp.comsquared.com [209.155.237.140])
	by mail.postgresql.org (Postfix) with ESMTP id DC4471337B53
	for <pgsql-sql@postgresql.org>; Fri, 21 Jan 2011 11:04:51 -0400 (AST)
Received: from mdpserv.comsquared.com (mdpserv [10.82.40.1])
	by smtp.comsquared.com (Switch-3.2.7/Switch-3.2.7) with ESMTP id
	p0LElTZr020820
	for <pgsql-sql@postgresql.org>; Fri, 21 Jan 2011 09:47:32 -0500 (EST)
Received: from erouse052008 (erouse052008.ntc2s.comsquared.com [10.82.60.61])
	by mdpserv.comsquared.com (8.13.6+Sun/8.13.6) with ESMTP id
	p0LElSfJ005824
	for <pgsql-sql@postgresql.org>; Fri, 21 Jan 2011 09:47:29 -0500 (EST)
From: "Edward W. Rouse" <erouse@comsquared.com>
To: <pgsql-sql@postgresql.org>
References: <2C43C4BE6357654AB4E898C9E9EBA83E32BC2849@mbx.in.v2solutions.com>
	<20110121105728.GJ80182@spoetnik.xs4all.nl>
	<2C43C4BE6357654AB4E898C9E9EBA83E32BC287B@mbx.in.v2solutions.com>
In-Reply-To: <2C43C4BE6357654AB4E898C9E9EBA83E32BC287B@mbx.in.v2solutions.com>
Subject: Re: Issue with postgres connectivity
Date: Fri, 21 Jan 2011 09:47:29 -0500
Message-ID: <08a501cbb97a$20e61790$62b246b0$@com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Mailer: Microsoft Office Outlook 12.0
Thread-Index: AQHLuVspcTEDykBfXkqhZPwpCw5z4ZPbTePQgAAzgjA=
Content-Language: en-us
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.91 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
	T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201101/60
X-Sequence-Number: 35007

When was the last time you did a vacuum analyze?

Edward W. Rouse


-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]
On Behalf Of Arindam Hore
Sent: Friday, January 21, 2011 6:44 AM
To: Reinoud van Leeuwen; pgsql-sql@postgresql.org
Subject: Re: [SQL] Issue with postgres connectivity

We are accessing database using ip address.

-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]
On Behalf Of Reinoud van Leeuwen
Sent: Friday, January 21, 2011 4:27 PM
To: pgsql-sql@postgresql.org
Subject: Re: [SQL] Issue with postgres connectivity

On Fri, Jan 21, 2011 at 10:45:37AM +0000, Arindam Hore wrote:
> Hello All,
>
> I am facing a big problem in postgres connectivity using php application.
It is taking almost 10 sec for connection establishment. All my applications
were working perfectly 2 days before. Yesterday just it started giving
problem. Using pg-admin also it is taking time to connect as well as same
with opening server status window or with sql query window.
>
> Postgres is installed in linux environment. Don't know whether is it due
to some virus or something else.
>
> Please provide me with some guidelines. Ask me any queries.

this smells like DNS resolving...

Reinoud

--
__________________________________________________
"Nothing is as subjective as reality"
Reinoud van Leeuwen    reinoud.v@n.leeuwen.net
http://reinoud.van.leeuwen.net kvk 27320762
__________________________________________________

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.
This message contains confidential information and is intended only for the
individual named. If you are not the named addressee you should not
disseminate, distribute or copy this e-mail.

-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql




From jasen@xnet.co.nz Sat Jan  22 08:54:01 2011
Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id 19EE61337B47
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Sat, 22 Jan 2011 04:54:01 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 10709-01 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Sat, 22 Jan 2011 08:53:53 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from smtpcorp.com (smtpcorp.com [174.143.60.32])
	by mail.postgresql.org (Postfix) with ESMTP id 963D51336B42
	for <pgsql-sql@postgresql.org>; Sat, 22 Jan 2011 04:53:53 -0400 (AST)
DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed;
 d=smtpcorp.com;
	s=main;
	h=Content-Transfer-Encoding:Content-Type:Mime-Version:References:Message-ID:Date:Subject:From:To;
	bh=l8zQb6GU+bxNyxNQe2YS4JB4vx+OmXv/y6N+uBPVsbw=;
	b=TVd0yjyJBhfaaFOn1D9Lsh0Hx0odhLtHTZWShzpryluaU2HB/H6LaHAYlXYQniBmROJtxCO15QZoFBwoXaleUfyY1S5u7/EHPNopZCkH6p9tbccvHyITgM7iIcK9HMmW;
Received: from ip-118-90-133-118.xdsl.xnet.co.nz ([118.90.133.118] helo=gonzo)
	by smtpcorp.com with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.70)
	id 1PgZEI-0001jS-8w; mid 144
	for pgsql-sql@postgresql.org; Sat, 22 Jan 2011 08:53:54 +0000
Received: from news by gonzo with local (Exim 4.72)
	(envelope-from <news@reversiblemaps.ath.cx>) id 1PgZE4-0004iO-Vl
	for pgsql-sql@postgresql.org; Sat, 22 Jan 2011 21:53:41 +1300
To: pgsql-sql@postgresql.org
Path: not-for-mail
From: Jasen Betts <jasen@xnet.co.nz>
Newsgroups: gmane.comp.db.postgresql.sql
Subject: Re: Issue with postgres connectivity
Date: 22 Jan 2011 08:53:40 GMT
Organization: Dis (not Dat) Organisation
Lines: 11
Message-ID: <ihe5uk$hl3$1@reversiblemaps.ath.cx>
References: <2C43C4BE6357654AB4E898C9E9EBA83E32BC2849@mbx.in.v2solutions.com>
	<20110121105728.GJ80182@spoetnik.xs4all.nl>
	<2C43C4BE6357654AB4E898C9E9EBA83E32BC287B@mbx.in.v2solutions.com>
NNTP-Posting-Host: localhost
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
X-Trace: reversiblemaps.ath.cx 1295686420 18083 127.0.0.1 (22 Jan 2011
	08:53:40 GMT)
X-Face: ?)Aw4rXwN5u0~$nqKj`xPz>xHCwgi^q+^?Ri*+R(&uv2=E1Q0Zk(>h!~o2ID@6{uf8s; a
	+M[5[U[QT7xFN%^gR"=tuJw%TXXR'Fp~W;
	(T"1(739R%m0Yyyv*gkGoPA.$b,D.w:z+<'"=-lVT?6
	{T?=R^:W5g|E2#EhjKCa+nt":4b}dU7GYB*HBxn&Td$@f%.kl^:7X8rQWd[NTc"P"u6nkisze/Q;
	8 "9Z{peQF,w)7UjV$c|RO/mQW/NMgWfr5*$-Z%u46"/00mx-,\R'fLPe.)^
User-Agent: slrn/pre1.0.0-18 (Linux)
X-Smtpcorp-Track: 21154670.1.13452079
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9
X-Spam-Level: 
X-Archive-Number: 201101/61
X-Sequence-Number: 35008

On 2011-01-21, Arindam Hore <arindam.hore@in.v2solutions.com> wrote:
> We are accessing database using ip address.

try adding the IP addresses of some of the clients as seen by the
server to /etc/hosts on the server. see if that helps.

try connecting to the server locally using 'su postgres -c psql'
see if that's slow too.

-- 
⚂⚃ 100% natural



From arindam.hore@in.v2solutions.com Sat Jan  22 15:41:52 2011
Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id B384B1337B5C
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Sat, 22 Jan 2011 11:41:52 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 47048-10 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Sat, 22 Jan 2011 15:41:45 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from webmail.in.v2solutions.com (unknown [122.182.0.74])
	by mail.postgresql.org (Postfix) with ESMTP id A898B1337B4F
	for <pgsql-sql@postgresql.org>; Sat, 22 Jan 2011 11:41:43 -0400 (AST)
Received: from mbx.in.v2solutions.com ([::1]) by casnhub.in.v2solutions.com
	([::1]) with mapi; Sat, 22 Jan 2011 21:10:54 +0530
From: Arindam Hore <arindam.hore@in.v2solutions.com>
To: "Edward W. Rouse" <erouse@comsquared.com>, "pgsql-sql@postgresql.org"
	<pgsql-sql@postgresql.org>
Subject: Re: Issue with postgres connectivity
Thread-Topic: [SQL] Issue with postgres connectivity
Thread-Index: AQHLuVspcTEDykBfXkqhZPwpCw5z4ZPbTePQgAAzgjCAAaEAoA==
Date: Sat, 22 Jan 2011 15:40:37 +0000
Message-ID: <2C43C4BE6357654AB4E898C9E9EBA83E32BC2E60@mbx.in.v2solutions.com>
References: <2C43C4BE6357654AB4E898C9E9EBA83E32BC2849@mbx.in.v2solutions.com>
	<20110121105728.GJ80182@spoetnik.xs4all.nl>
	<2C43C4BE6357654AB4E898C9E9EBA83E32BC287B@mbx.in.v2solutions.com>
	<08a501cbb97a$20e61790$62b246b0$@com>
In-Reply-To: <08a501cbb97a$20e61790$62b246b0$@com>
Accept-Language: en-US
Content-Language: en-US
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.107 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
	RDNS_NONE=0.793
X-Spam-Level: 
X-Archive-Number: 201101/65
X-Sequence-Number: 35012

Sorry for late reply. We usually do vacuum analyze daily basis using cron.

-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org=
] On Behalf Of Edward W. Rouse
Sent: Friday, January 21, 2011 8:17 PM
To: pgsql-sql@postgresql.org
Subject: Re: [SQL] Issue with postgres connectivity

When was the last time you did a vacuum analyze?

Edward W. Rouse


-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org=
]
On Behalf Of Arindam Hore
Sent: Friday, January 21, 2011 6:44 AM
To: Reinoud van Leeuwen; pgsql-sql@postgresql.org
Subject: Re: [SQL] Issue with postgres connectivity

We are accessing database using ip address.

-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org=
]
On Behalf Of Reinoud van Leeuwen
Sent: Friday, January 21, 2011 4:27 PM
To: pgsql-sql@postgresql.org
Subject: Re: [SQL] Issue with postgres connectivity

On Fri, Jan 21, 2011 at 10:45:37AM +0000, Arindam Hore wrote:
> Hello All,
>
> I am facing a big problem in postgres connectivity using php application.
It is taking almost 10 sec for connection establishment. All my application=
s
were working perfectly 2 days before. Yesterday just it started giving
problem. Using pg-admin also it is taking time to connect as well as same
with opening server status window or with sql query window.
>
> Postgres is installed in linux environment. Don't know whether is it due
to some virus or something else.
>
> Please provide me with some guidelines. Ask me any queries.

this smells like DNS resolving...

Reinoud

--
__________________________________________________
"Nothing is as subjective as reality"
Reinoud van Leeuwen    reinoud.v@n.leeuwen.net
http://reinoud.van.leeuwen.net kvk 27320762
__________________________________________________

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.
This message contains confidential information and is intended only for the
individual named. If you are not the named addressee you should not
disseminate, distribute or copy this e-mail.

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql


--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
This email and any files transmitted with it are confidential and intended =
solely for the use of the individual or entity to whom they are addressed. =
If you have received this email in error please notify the system manager. =
This message contains confidential information and is intended only for the=
 individual named. If you are not the named addressee you should not dissem=
inate, distribute or copy this e-mail.



From arindam.hore@in.v2solutions.com Sat Jan  22 15:44:16 2011
Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 847941337B4F
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Sat, 22 Jan 2011 11:44:16 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 98373-07 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Sat, 22 Jan 2011 15:44:11 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from webmail.in.v2solutions.com (unknown [122.182.0.74])
	by mail.postgresql.org (Postfix) with ESMTP id 546AC13364DE
	for <pgsql-sql@postgresql.org>; Sat, 22 Jan 2011 11:44:08 -0400 (AST)
Received: from mbx.in.v2solutions.com ([::1]) by casnhub.in.v2solutions.com
	([::1]) with mapi; Sat, 22 Jan 2011 21:13:54 +0530
From: Arindam Hore <arindam.hore@in.v2solutions.com>
To: Jasen Betts <jasen@xnet.co.nz>, "pgsql-sql@postgresql.org"
	<pgsql-sql@postgresql.org>
Subject: Re: Issue with postgres connectivity
Thread-Topic: [SQL] Issue with postgres connectivity
Thread-Index: AQHLuVspcTEDykBfXkqhZPwpCw5z4ZPbTePQgAFjbtOAAHF6wA==
Date: Sat, 22 Jan 2011 15:43:18 +0000
Message-ID: <2C43C4BE6357654AB4E898C9E9EBA83E32BC2E71@mbx.in.v2solutions.com>
References: <2C43C4BE6357654AB4E898C9E9EBA83E32BC2849@mbx.in.v2solutions.com>
	<20110121105728.GJ80182@spoetnik.xs4all.nl>
	<2C43C4BE6357654AB4E898C9E9EBA83E32BC287B@mbx.in.v2solutions.com>
	<ihe5uk$hl3$1@reversiblemaps.ath.cx>
In-Reply-To: <ihe5uk$hl3$1@reversiblemaps.ath.cx>
Accept-Language: en-US
Content-Language: en-US
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: base64
MIME-Version: 1.0
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.107 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
	RDNS_NONE=0.793
X-Spam-Level: 
X-Archive-Number: 201101/66
X-Sequence-Number: 35013

V2hhdCBJIGhhdmUgc2VlbiBpcyB0aGF0LCB3aGVuIEkgYW0gdHJ5aW5nIHRvIGNvbm5lY3QgdGhl
IGRiIHNlcnZlciBmcm9tIGFwcGxpY2F0aW9uIHNlcnZlciB1c2luZyBzc2gsIHRoZSByZXNwb25z
ZSB3YXMgdmVyeSBzbG93LiBXaGlsZSBmcm9tIGRiIHNlcnZlciB0byBhcHBsaWNhdGlvbiBzZXJ2
ZXIgaXQgaXMgdmVyeSBxdWljayBhcyB1c3VhbGx5Lg0KDQotLS0tLU9yaWdpbmFsIE1lc3NhZ2Ut
LS0tLQ0KRnJvbTogcGdzcWwtc3FsLW93bmVyQHBvc3RncmVzcWwub3JnIFttYWlsdG86cGdzcWwt
c3FsLW93bmVyQHBvc3RncmVzcWwub3JnXSBPbiBCZWhhbGYgT2YgSmFzZW4gQmV0dHMNClNlbnQ6
IFNhdHVyZGF5LCBKYW51YXJ5IDIyLCAyMDExIDI6MjQgUE0NClRvOiBwZ3NxbC1zcWxAcG9zdGdy
ZXNxbC5vcmcNClN1YmplY3Q6IFJlOiBbU1FMXSBJc3N1ZSB3aXRoIHBvc3RncmVzIGNvbm5lY3Rp
dml0eQ0KDQpPbiAyMDExLTAxLTIxLCBBcmluZGFtIEhvcmUgPGFyaW5kYW0uaG9yZUBpbi52MnNv
bHV0aW9ucy5jb20+IHdyb3RlOg0KPiBXZSBhcmUgYWNjZXNzaW5nIGRhdGFiYXNlIHVzaW5nIGlw
IGFkZHJlc3MuDQoNCnRyeSBhZGRpbmcgdGhlIElQIGFkZHJlc3NlcyBvZiBzb21lIG9mIHRoZSBj
bGllbnRzIGFzIHNlZW4gYnkgdGhlDQpzZXJ2ZXIgdG8gL2V0Yy9ob3N0cyBvbiB0aGUgc2VydmVy
LiBzZWUgaWYgdGhhdCBoZWxwcy4NCg0KdHJ5IGNvbm5lY3RpbmcgdG8gdGhlIHNlcnZlciBsb2Nh
bGx5IHVzaW5nICdzdSBwb3N0Z3JlcyAtYyBwc3FsJw0Kc2VlIGlmIHRoYXQncyBzbG93IHRvby4N
Cg0KLS0NCuKaguKagyAxMDAlIG5hdHVyYWwNCg0KLS0NClNlbnQgdmlhIHBnc3FsLXNxbCBtYWls
aW5nIGxpc3QgKHBnc3FsLXNxbEBwb3N0Z3Jlc3FsLm9yZykNClRvIG1ha2UgY2hhbmdlcyB0byB5
b3VyIHN1YnNjcmlwdGlvbjoNCmh0dHA6Ly93d3cucG9zdGdyZXNxbC5vcmcvbWFpbHByZWYvcGdz
cWwtc3FsDQpUaGlzIGVtYWlsIGFuZCBhbnkgZmlsZXMgdHJhbnNtaXR0ZWQgd2l0aCBpdCBhcmUg
Y29uZmlkZW50aWFsIGFuZCBpbnRlbmRlZCBzb2xlbHkgZm9yIHRoZSB1c2Ugb2YgdGhlIGluZGl2
aWR1YWwgb3IgZW50aXR5IHRvIHdob20gdGhleSBhcmUgYWRkcmVzc2VkLiBJZiB5b3UgaGF2ZSBy
ZWNlaXZlZCB0aGlzIGVtYWlsIGluIGVycm9yIHBsZWFzZSBub3RpZnkgdGhlIHN5c3RlbSBtYW5h
Z2VyLiBUaGlzIG1lc3NhZ2UgY29udGFpbnMgY29uZmlkZW50aWFsIGluZm9ybWF0aW9uIGFuZCBp
cyBpbnRlbmRlZCBvbmx5IGZvciB0aGUgaW5kaXZpZHVhbCBuYW1lZC4gSWYgeW91IGFyZSBub3Qg
dGhlIG5hbWVkIGFkZHJlc3NlZSB5b3Ugc2hvdWxkIG5vdCBkaXNzZW1pbmF0ZSwgZGlzdHJpYnV0
ZSBvciBjb3B5IHRoaXMgZS1tYWlsLg0K