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
pgsql-performance by date
|Next:||From: Enrico Weigelt||Date: 2005-03-24 13:48:05|
|Subject: Re: View columns calculated|
|Previous:||From: Enrico Weigelt||Date: 2005-03-24 13:32:48|
|Subject: clear function cache (WAS: SQL function inlining)|