Re: [PERFORM] clear function cache (WAS: SQL function inlining)

2005-04-15 Thread Enrico Weigelt
* Stephan Szabo <[EMAIL PROTECTED]> wrote: > > On Thu, 24 Mar 2005, Enrico Weigelt wrote: > > > * Alvaro Herrera <[EMAIL PROTECTED]> 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 > > > > f

Re: [PERFORM] clear function cache (WAS: SQL function inlining)

2005-03-24 Thread Stephan Szabo
On Thu, 24 Mar 2005, Enrico Weigelt wrote: > * Alvaro Herrera <[EMAIL PROTECTED]> 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 func

Re: [PERFORM] clear function cache (WAS: SQL function inlining)

2005-03-24 Thread Enrico Weigelt
* Alvaro Herrera <[EMAIL PROTECTED]> 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 ? > > I'd

Re: [PERFORM] clear function cache (WAS: SQL function inlining)

2005-03-24 Thread Alvaro Herrera
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

[PERFORM] clear function cache (WAS: SQL function inlining)

2005-03-24 Thread Enrico Weigelt
* Tom Lane <[EMAIL PROTECTED]> wrote: BTW: is it possible to explicitly clear the cache for immutable functions ? 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