Re: How clear the cache on postgresql?

From: bricklen <bricklen(at)gmail(dot)com>
To: hmidi slim <hmidi(dot)slim2(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: How clear the cache on postgresql?
Date: 2017-11-24 15:00:43
Message-ID: CAGrpgQ9eBOiVNF-LGCzN_E6FgErjBQ5xsUi8TVcxvDh+jwqUqg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Nov 24, 2017 at 6: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?
>
​
If you are on a (non-production) *nix server you can use:
sync && echo 3 > /proc/sys/vm/drop_caches​

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2017-11-24 16:55:52 Re: How clear the cache on postgresql?
Previous Message hmidi slim 2017-11-24 14:54:59 How clear the cache on postgresql?