Re: Discarding the resulting rows

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Robert Haas" <robertmhaas(at)gmail(dot)com>
Cc: <pgsql-hackers(at)postgresql(dot)org>, "Murali M(dot) Krishna" <murali1729(at)yahoo(dot)com>
Subject: Re: Discarding the resulting rows
Date: 2010-04-26 20:24:02
Message-ID: 4BD5B0120200002500030E1C@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> On Mon, Apr 26, 2010 at 3:36 PM, Kevin Grittner
> <Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
>> "Murali M. Krishna" <murali1729(at)yahoo(dot)com> wrote:
>>
>>> Basically, I would like to discard the result rows after doing
>>> all the work required to execute the query.
>>
>> I would use EXPLAIN ANALYZE SELECT ...
>
> There's some overhead to that, of course.

Good point. At the moment I can't think how to do better, though.

Other suggestions, anyone?

-Kevin

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2010-04-26 20:25:35 Re: Discarding the resulting rows
Previous Message Alvaro Herrera 2010-04-26 20:18:47 Re: global temporary tables