From: Scott Marlowe <smarlowe@g2switchworks.com>
To: Thomas Vatter <thomas.vatter@network-inventory.de>
Cc: Tino Wildenhain <tino@wildenhain.de>
Cc: pgsql-performance@postgresql.org
Subject: Re: in memory views
Date: Wed, 10 May 2006 10:45:06 -0500
Message-ID: <1147275906.9755.25.camel@state.g2switchworks.com> (raw)
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>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: smarlowe@g2switchworks.com, thomas.vatter@network-inventory.de, tino@wildenhain.de
Subject: Re: in memory views
In-Reply-To: <1147275906.9755.25.camel@state.g2switchworks.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox