From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | bricklen <bricklen(at)gmail(dot)com> |
Cc: | hmidi slim <hmidi(dot)slim2(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: How clear the cache on postgresql? |
Date: | 2017-11-24 16:55:52 |
Message-ID: | 29149.1511542552@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
bricklen <bricklen(at)gmail(dot)com> writes:
> 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
You would also need to restart the postmaster, to get rid of whatever
is in Postgres' shared buffers.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | hmidi slim | 2017-11-24 17:09:42 | Re: How clear the cache on postgresql? |
Previous Message | bricklen | 2017-11-24 15:00:43 | Re: How clear the cache on postgresql? |