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