Re: No caching sql query

[Nik Tek <niktek2005@xxxxxxxxx>]

Prabhjot,

You could clear the cache at the disk level, not at the db level.

Follow the link: http://linux-mm.org/Drop_Caches

You can look into the cache by using pg_buffercache, if you want to.

Hope it helps

Nik

On Wed, Aug 21, 2013 at 1:31 PM, Prabhjot Sheena <prabhjot.sheena@xxxxxxxxxxxxxx> wrote:

or is there a command to flush cache out

Thx

On Wed, Aug 21, 2013 at 1:28 PM, Prabhjot Sheena <prabhjot.sheena@xxxxxxxxxxxxxx> wrote:

Hi guys

          Is there a way to not cache sql query that just finished executing. I have a scenario in which i want to run a sql query but i don't want it to sit in cache. i want it to be cleared from cache as soon as it displays me the result. Is that possible

Thanks