Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 8E0B41337990 for ; 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 ; 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 ; 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 ; 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 ; Fri, 21 Jan 2011 09:47:29 -0500 (EST) From: "Edward W. Rouse" To: 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