| 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: | Whole Thread | Raw Message | 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
| 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 |