Remove query results from cache

Поиск
Список
Период
Сортировка
От André Volpato
Тема Remove query results from cache
Дата
Msg-id 465487CC.8040904@ecomtecnologia.com.br
обсуждение исходный текст
Ответ на Re: Vacuum DB in Postgres Vs similar concept in other RDBMS  ("Alexander Staubo" <alex@purefiction.net>)
Ответы Re: Remove query results from cache  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-general
Hello,

Is there any way to remove the results of certain query, from the memory
cache ?
I´m doing some performance tests, and I need the planner to make his
work every time I run the statements, without changing them.

Running vmstat, I can se the memory cache grows, and the planner do not
'forget' the results of any query until the cache reach 2 Gb (total box
RAM) , or the server is rebooted.

--
[]´s,

André Volpato
ECOM Tecnologia Ltda
andre.volpato@ecomtecnologia.com.br
(41) 3014 2322



В списке pgsql-general по дате отправления:

Предыдущее
От: Donald Laurine
Дата:
Сообщение: Performance
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Tsearch2: upgrading from postgres 8.1.x to 8.2.x