Re: clear function cache (WAS: SQL function inlining)

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Enrico Weigelt <weigelt(at)metux(dot)de>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: clear function cache (WAS: SQL function inlining)
Date: 2005-03-24 14:58:34
Message-ID: 20050324065516.P34192@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


On Thu, 24 Mar 2005, Enrico Weigelt wrote:

> * Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Otto Blomqvist 2005-03-24 18:17:06 pg_autovacuum not having enough suction ?
Previous Message Gustavo Franklin Nóbrega - Planae 2005-03-24 14:28:30 Re: CPU 0.1% IOWAIT 99% for decisonnal queries