Postgres Pro
Downloads
Home   >   mailing lists

Re: How to clear buffer - Mailing list pgsql-general

From Pete Hollobon
Subject Re: How to clear buffer
Date
Msg-id CACojYcFTVpozZ7_hG+s2_FZWJB79TtfVL3564PepepQ-cLyu0w@mail.gmail.com
Whole thread Raw
In response to How to clear buffer  (Ravi Krishna <s.ravikrishna@aim.com>)
List pgsql-general
Tree view
I wrote a few notes on doing this here: http://hollobon.com/_pgblog/clear_shared_buffers.html

Thanks,
Pete.

On 13 May 2015 at 09:13, Ravi Krishna <s.ravikrishna@aim.com> wrote:
I am writing bench mark scripts and as part of it would like to clear the cache
programmatically. This is to ensure that when we run select queries the data is
not read read from the cache. Does PG provide any easy way to do it other than
the obvious way to restart the database.

Thanks.


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Gavin Flower
Date:
Subject: Re: How to clear buffer
Next
From: Yoong Zhen Ang
Date:
Subject: PostgreSQL OGC compliant