Re: [GENERAL] No caching sql query

[Nik Tek]

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

[GENERAL] Find all the the SELECT statements that occured

[Nik Tek]

Hi,

I have a question on how to find all the SELECT statements that have
occurred in the database. I don't want any DML(Insert/Update/Delete)
statements to be captured. This is for knowing how many selects statements
occur within the database in an 1 hour interval or on a average.

Would this simple or possible in postgres?

Thank you
Nik