Re: How clear the cache on postgresql?

On Fri, Nov 24, 2017 at 8:54 AM, hmidi slim <hmidi(dot)slim2(at)gmail(dot)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