On Fri, Nov 24, 2017 at 8:54 AM, hmidi slim <hmidi.slim2@xxxxxxxxx> wrote:
I'm trying to analyze some queries using the explain instructions and the option analyze and buffers. I realized that the query refers to the cache memory to return the results. Is there any solution to clear the cache in postgresql inorder to get execution time of the query when it get data from disk and not from cache memory?
There are so many different levels of caching going on--within Postgresql, within the OS, within a disk array or SAN, and at the individual drive--that there may no longer be a meaningful way to perform this measurement.
--
Mike Nolan
