Re: How clear the cache on postgresql?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: How clear the cache on postgresql?
Дата
Msg-id 29149.1511542552@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: How clear the cache on postgresql?  (bricklen <bricklen@gmail.com>)
Ответы Re: How clear the cache on postgresql?  (hmidi slim <hmidi.slim2@gmail.com>)
Список pgsql-general
bricklen <bricklen@gmail.com> writes:
> On Fri, Nov 24, 2017 at 6:54 AM, hmidi slim <hmidi.slim2@gmail.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


В списке pgsql-general по дате отправления:

Предыдущее
От: bricklen
Дата:
Сообщение: Re: How clear the cache on postgresql?
Следующее
От: hmidi slim
Дата:
Сообщение: Re: How clear the cache on postgresql?