Re: How to clear buffer

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
>

In response to

Browse pgsql-general by date

  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