| 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: | Whole Thread | Raw Message | 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 |