> "Donald Fraser" writes:
>> Is the returned value of a function defined as IMMUTABLE cached =
"Tom Lane" writes:
> No, in fact it isn't cached at all. IMMUTABLE tells the planner that
> it's OK to fold a function call with constant inputs to a constant
> result value at plan time. Nothing more.
Ok I'm sort of clutching at straws here...
What about this scenario: I'm aware that sql statements within PL/pgSQL
functions get cached. Therefore if the query planner can fold a function with a
constant result, could that query plan get cached by PL/pgSQL with a folded
In response to
pgsql-admin by date
|Next:||From: KÖPFERL Robert||Date: 2005-06-24 13:18:12|
|Subject: symlinking pg_xlog|
|Previous:||From: Hannes Dorbath||Date: 2005-06-24 09:47:01|