On Thu, Nov 04, 2010 at 08:24:14PM -0400, Carlo Stonebanks wrote: > We have procs that would benefit from returning IMMUTABLE results. > The procs are dependent on external tables that rarely change, but > when they DO change, it would be great if we could expire the cache > that the procs read from so that the procs are forced to re-evaluate > the results. > > Is this possible? > > How do I know how many possible results are cached?
in addition to what Leif responded, please note that immutable functions *do not* cache results. depesz -- Linkedin: http://www.linkedin.com/in/depesz / blog: http://www.depesz.com/ jid/gtalk: dep...@depesz.com / aim:depeszhdl / skype:depesz_hdl / gg:6749007 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
