Discarding the resulting rows

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!