Skip site navigation (1) Skip section navigation (2)

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

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
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 13:42:40
Message-ID: 20050324134240.GD20726@dcc.uchile.cl (view raw or flat)
Thread:
Lists: pgsql-performance
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.

> I'd like to use immutable functions for really often lookups like 
> fetching a username by uid and vice versa. The queried tables 
> change very rarely, but when they change is quite unpredictable.

Maybe you should use a stable function if you fear we'll having function
result caching without you noticing.

-- 
Alvaro Herrera (<alvherre[(at)]dcc(dot)uchile(dot)cl>)
"Aprende a avergonzarte más ante ti que ante los demás" (Demócrito)

In response to

Responses

pgsql-performance by date

Next:From: Enrico WeigeltDate: 2005-03-24 13:48:05
Subject: Re: View columns calculated
Previous:From: Enrico WeigeltDate: 2005-03-24 13:32:48
Subject: clear function cache (WAS: SQL function inlining)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group