X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E6AEA52917 for ; Wed, 17 Aug 2005 07:29:06 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 34451-06 for ; Wed, 17 Aug 2005 10:29:03 +0000 (GMT) Received: from my.endian.it (unknown [62.146.87.34]) by svr1.postgresql.org (Postfix) with ESMTP id F1989528F0 for ; Wed, 17 Aug 2005 07:29:00 -0300 (ADT) Received: from dell.1006.org (host58-128.pool8251.interbusiness.it [82.51.128.58]) (authenticated (0 bits)) by my.endian.it (8.11.6/8.11.6) with ESMTP id j7HAKZx06697; Wed, 17 Aug 2005 12:20:35 +0200 Subject: Re: Data Selection Slow From VB 6.0 From: Chris Mair To: Mahesh Shinde Cc: pgsql-performance@postgresql.org In-Reply-To: <009501c5a311$3706ef20$dd0aa8c0@codecindia.com> References: <009501c5a311$3706ef20$dd0aa8c0@codecindia.com> Content-Type: text/plain Date: Wed, 17 Aug 2005 12:28:16 +0200 Message-Id: <1124274496.2651.9.camel@dell.1006.org> Mime-Version: 1.0 X-Mailer: Evolution 2.2.3 (2.2.3-2.fc4) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 required=5 tests=[FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200508/202 X-Sequence-Number: 13949 > When I fire a query to search a debtor id, it took around 5 seconds > to return an answer for a query [...] Are you sure that time is actually spent in the database engine? Maybe there are DNS resolving issues or something... Did you try to execute the queries directly on the server from the psql shell? Bye, Chris. >