Remove query results from cache - Mailing list pgsql-general

From André Volpato
Subject Remove query results from cache
Date
Msg-id 465487CC.8040904@ecomtecnologia.com.br
Whole thread Raw
In response to Re: Vacuum DB in Postgres Vs similar concept in other RDBMS  ("Alexander Staubo" <alex@purefiction.net>)
Responses Re: Remove query results from cache
List 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 by date:

Previous
From: Donald Laurine
Date:
Subject: Performance
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Tsearch2: upgrading from postgres 8.1.x to 8.2.x