Postgres Pro
Downloads
Home   >   mailing lists

Re: No caching sql query - Mailing list pgsql-general

From Nik Tek
Subject Re: No caching sql query
Date
Msg-id CAHySzWUes-qVwJ8PE8EtU8sa0WdQnuKCgH3_i2e7dwYeOHY=XQ@mail.gmail.com
Whole thread Raw
In response to Re: No caching sql query  (Prabhjot Sheena <prabhjot.sheena@rivalwatch.com>)
List pgsql-general
Tree view
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:
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 possible

Thanks


pgsql-general by date:

Previous
From: Sergey Konoplev
Date:
Subject: Re: Strange message from pg_receivexlog
Next
From: 高健
Date:
Subject: How to know detailed information about HOT(Heap-Only Tuples)?