Discarding the resulting rows
От | Murali M. Krishna |
---|---|
Тема | Discarding the resulting rows |
Дата | |
Msg-id | 217821.21571.qm@web52808.mail.re2.yahoo.com обсуждение исходный текст |
Ответы |
Re: Discarding the resulting rows
|
Список | 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 по дате отправления: