Re: No caching sql query

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(dot)sheena(at)rivalwatch(dot)com> wrote:

> or is there a command to flush cache out
>
> Thx
>
>
> On Wed, Aug 21, 2013 at 1:28 PM, Prabhjot Sheena <
> prabhjot(dot)sheena(at)rivalwatch(dot)com> 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
>>
>
>