When was the last time you did a vacuum analyze?
Edward W. Rouse
-Original Message-
From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql-ow...@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:
We are accessing database using ip address.
-Original Message-
From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql-ow...@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 connectiv
Thanks Reinoud for quick reply. How can I test it? Is there any way?
-Original Message-
From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql-ow...@postgresql.org] On
Behalf Of Reinoud van Leeuwen
Sent: Friday, January 21, 2011 4:27 PM
To: pgsql-sql@postgresql.org
Subject: Re: [SQL] Issu
On Fri, Jan 21, 2011 at 10:45:37AM +, 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 starte
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 w