Re: No caching sql query
| От | Nik Tek |
|---|---|
| Тема | Re: No caching sql query |
| Дата | |
| Msg-id | CAHySzWUes-qVwJ8PE8EtU8sa0WdQnuKCgH3_i2e7dwYeOHY=XQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: No caching sql query (Prabhjot Sheena <prabhjot.sheena@rivalwatch.com>) |
| Список | pgsql-general |
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
В списке pgsql-general по дате отправления: