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?
- How clear the cache on postgresql? hmidi slim
- Re: How clear the cache on postgresql? bricklen
- Re: How clear the cache on postgresql? Tom Lane
- Re: How clear the cache on postgresql? hmidi slim
- Re: How clear the cache on postgresql... Jeff Janes
- Re: How clear the cache on postgresql? Michael Nolan
- Re: How clear the cache on postgresql? John R Pierce
- Re: How clear the cache on postgresql? Adam Tauno Williams
- Re: How clear the cache on postgresql... Jérôme Étévé