Hello Hackers: Two questions.
1. I would like to execute queries such as select * from part and time the query. But I want to ignore how much time is taken for printing the result to a file or the screen. Basically, I would like to discard the result rows after doing all the work required to execute the query. I looked at the documentation and I saw something about using the keyword PERFORM rather than SELECT. I tried PERFORM * from part; But this gave me a syntax error. Please let me know how this can be done. 2. How do I clear the buffer caches between two query runs? I believe this is not possible in Postgres. Can someone please confirm this or tell me how it may be done. Thanks, Murali. ----------------------------------------------------------------- Please visit NumberFest.com for educational number puzzles & mind exercises for all ages! And please tell your friends about it. Thank You!