Thread: No caching sql query
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
or is there a command to flush cache out
Thx
On Wed, Aug 21, 2013 at 1:28 PM, Prabhjot Sheena <prabhjot.sheena@rivalwatch.com> wrote:
Hi guysIs 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 possibleThanks
Prabhjot,
You could clear the cache at the disk level, not at the db level.
Follow the link: http://linux-mm.org/Drop_CachesYou 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@rivalwatch.com> wrote:
or is there a command to flush cache outThxOn Wed, Aug 21, 2013 at 1:28 PM, Prabhjot Sheena <prabhjot.sheena@rivalwatch.com> wrote:Hi guysIs 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 possibleThanks