Re: [GENERAL] How to clear buffer

2015-05-13 Thread Pete Hollobon
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 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 sel

Re: [GENERAL] How to clear buffer

2015-05-13 Thread Gavin Flower
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

[GENERAL] How to clear buffer

2015-05-13 Thread Ravi Krishna
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