Re: clear function cache (WAS: SQL function inlining) - Mailing list pgsql-performance

On Thu, 24 Mar 2005, Enrico Weigelt wrote:

> * Alvaro Herrera <alvherre@dcc.uchile.cl> wrote:
> > On Thu, Mar 24, 2005 at 02:32:48PM +0100, Enrico Weigelt wrote:
> >
> > > BTW: is it possible to explicitly clear the cache for immutable
> > > functions ?
> >
> > What cache?  There is no caching of function results.
>
> Not ? So what's immutable for ?

For knowing that you can do things like use it in a functional index and
I think for things like constant folding in a prepared plan.