Re: [GENERAL] No caching sql query
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 >> > >
Re: [GENERAL] No caching sql query
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] 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