In the last episode (Aug 07), Paul DuBois said:
> At 23:16 +0100 8/7/04, Terry Riley wrote:
> > However, there appears to be no indication in the manual as to the
> > time that a cached query remains in memory. In the absence of this
> > information, is it safe to assume that a cached query remains there
> > indefinitely, unless either (1) one of the tables used in the
> > initial query is modified, or (2) the server is re-started?
> Yes. Why would you remove a result from the cache if it's still current?
> Actually, there is another condition:
> (3) you issue a RESET QUERY CACHE statement, which clears the entire
There's another one: (4) the data in the cache exceeds
query_cache_size, in which case old cached results will get purged to
make room for new ones.