Hi all,
I just got a quick question about warm-cache. I'm using PG 9.2.
When I execute this statement soon after I start/restart the database:
explain select id from test where id = 124;
The runtime is 40ms.
Then, If I execute this statement just after the above one;
explain analyze select id from test where id = 124;
The runtime is 0.8ms.
Probably the statement is cached, right?
So, I do (To clear the cache):
- service postgresql stop
- echo 3 > /proc/sys/vm/drop_caches
- service postgresql start
But, then, executing the statement again, it runs in 0.8 ms.
How can I clean the cache to get the REAL runtime for that statement?
Thanks
Patrick