Discarding the resulting rows - Mailing list pgsql-hackers

From Murali M. Krishna
Subject Discarding the resulting rows
Date
Msg-id 217821.21571.qm@web52808.mail.re2.yahoo.com
Whole thread Raw
Responses Re: Discarding the resulting rows  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-hackers
<table border="0" cellpadding="0" cellspacing="0"><tr><td style="font: inherit;" valign="top">Hello Hackers:<br /><br
/>Twoquestions.<br /><br />1.<br /><br />I would like to execute queries such as <br /><br />select * from part and
timethe query. But I want to ignore how much time is taken for printing the result to a file or the screen.<br /><br
/>Basically,I would like to discard the result rows after doing all the work required to execute the query.<br /><br
/>Ilooked at the documentation and I saw something about using the keyword PERFORM rather than SELECT.<br /><br />I
triedPERFORM * from part; <br /><br />But this gave me a syntax error.<br /><br />Please let me know how this can be
done.<br/><br />2.<br /><br />How do I clear the buffer caches between two query runs?<br />I believe this is not
possiblein Postgres. Can someone please confirm this or tell me how it may be done.<br /><br />Thanks,<br /><br
/>Murali.<br/><br /><br /><br />-----------------------------------------------------------------<br />Please visit <a
href="http://NumberFest.com"rel="nofollow" target="_blank">NumberFest.com</a> for educational number puzzles & mind
exercisesfor all ages! And please tell your friends about it. Thank You!<br /></td></tr></table><br /> 

pgsql-hackers by date:

Previous
From: "Erik Rijkers"
Date:
Subject: Re: testing HS/SR - 1 vs 2 performance
Next
From: Josh Berkus
Date:
Subject: Re: recovery_connections cannot start (was Re: master in standby mode croaks)