Postgres Pro
Downloads
Home   >   mailing lists

Thread: How to clear buffer

How to clear buffer

From
Ravi Krishna
Date:
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.

Re: How to clear buffer

From
Gavin Flower
Date:
On 13/05/15 20:13, Ravi Krishna 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.
>
>
Don't forget the O/S also caches things!

-Gavin

Re: How to clear buffer

From
Pete Hollobon
Date:
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