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:
Show quoted text
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 possibleThanks
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@rivalwatch.com> wrote:
Show quoted text
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 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 possibleThanks