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.ravikris...@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 >
