Hi,
I am increasing the shared_buffer size in postgresql.conf and want to measure its effect on READ. In essence I want to know if the SELECT queries I am firing repeatedly is reading from the buffer or going directly to the disk.
I am expecting the first SELECT to go to disk and the subsequent call of the same SELECT to read from buffer .
Right now I am just looking at execution time of the SELECTs and trying to conclude. But there should be a direct way to see where the SELECT reads from.
How can I accomplish this ?
Thanks
Bala
The New Busy think 9 to 5 is a cute idea. Combine multiple calendars with Hotmail.
Get busy.