How clear the cache on postgresql?

From: hmidi slim <hmidi(dot)slim2(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How clear the cache on postgresql?
Date: 2017-11-24 14:54:59
Message-ID: CAMsqVxuUm-yEJJM6JeLx5bFRpeOERyvyxDScoAsKaZN84G2XEA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message bricklen 2017-11-24 15:00:43 Re: How clear the cache on postgresql?
Previous Message hmidi slim 2017-11-24 14:48:48 Re: Buffers option