Postgres Pro
Downloads
Home   >   mailing lists

Re: Are cached IMMUTABLE values persistent between sessions - Mailing list pgsql-admin

From Tom Lane
Subject Re: Are cached IMMUTABLE values persistent between sessions
Date
Msg-id 4917.1119537183@sss.pgh.pa.us
Whole thread Raw
In response to Are cached IMMUTABLE values persistent between sessions  ("Donald Fraser" <postgres@kiwi-fraser.net>)
List pgsql-admin
Tree view 
"Donald Fraser" <postgres@kiwi-fraser.net> writes:
> Is the returned value of a function defined as IMMUTABLE cached =
> globally?

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.

            regards, tom lane

pgsql-admin by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Are cached IMMUTABLE values persistent between sessions
Next
From: Michael Fuhr
Date:
Subject: Re: Are cached IMMUTABLE values persistent between sessions