X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id E1A189FA2FA for ; Wed, 10 May 2006 12:45:17 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 17904-09 for ; Wed, 10 May 2006 12:45:08 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from exchange.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by postgresql.org (Postfix) with ESMTP id DA27B9FA1B0 for ; Wed, 10 May 2006 12:45:07 -0300 (ADT) Received: from 10.10.1.37 ([10.10.1.37]) by exchange.g2switchworks.com ([10.10.1.2]) with Microsoft Exchange Server HTTP-DAV ; Wed, 10 May 2006 15:45:06 +0000 Received: from state.g2switchworks.com by mail.g2switchworks.com; 10 May 2006 10:45:06 -0500 Subject: Re: in memory views From: Scott Marlowe To: Thomas Vatter Cc: Tino Wildenhain , pgsql-performance@postgresql.org In-Reply-To: <4462098D.2010500@network-inventory.de> References: <4461AFFF.7060200@network-inventory.de> <4461B3DE.6030700@wildenhain.de> <4461B899.4030502@network-inventory.de> <1147273917.9755.22.camel@state.g2switchworks.com> <4462098D.2010500@network-inventory.de> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1147275906.9755.25.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Wed, 10 May 2006 10:45:06 -0500 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/261 X-Sequence-Number: 19048 On Wed, 2006-05-10 at 10:41, Thomas Vatter wrote: > Scott Marlowe wrote: > > What happens if you do this by declaring it as a cursor and then > > fetching the first row? > > > > I do executeQuery(), for the resultSet I do next() and return one row, > but wait, I have to review the logic in this area, I can tell you > tomorrow A good short test is to run explain analyze on the query from the psql command line. If it shows an execution time of significantly less than what you get from you application, then it is likely that the real problem is that your application is receiving the whole result set via libpq and waiting for that. A cursor will solve that problem.