From: | Pete Hollobon <postgres(at)hollobon(dot)com> |
---|---|
To: | Ravi Krishna <s(dot)ravikrishna(at)aim(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: How to clear buffer |
Date: | 2015-05-13 08:38:25 |
Message-ID: | CACojYcFTVpozZ7_hG+s2_FZWJB79TtfVL3564PepepQ-cLyu0w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)ravikrishna(at)aim(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
From | Date | Subject | |
---|---|---|---|
Next Message | Yoong Zhen Ang | 2015-05-13 09:09:54 | PostgreSQL OGC compliant |
Previous Message | Gavin Flower | 2015-05-13 08:23:19 | Re: How to clear buffer |