On Fri, Nov 24, 2017 at 8:54 AM, hmidi slim <hmidi.sl...@gmail.com> 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
