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

Re: Are cached IMMUTABLE values persistent between sessions

From: Alvaro Herrera <alvherre(at)surnet(dot)cl>
To: Donald Fraser <postgres(at)kiwi-fraser(dot)net>
Cc: "[ADMIN]" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Are cached IMMUTABLE values persistent between sessions
Date: 2005-06-23 14:40:55
Message-ID: 20050623144055.GC7656@surnet.cl (view raw or flat)
Thread:
Lists: pgsql-admin
On Thu, Jun 23, 2005 at 02:26:23PM +0100, Donald Fraser wrote:
> Is the returned value of a function defined as IMMUTABLE cached
> globally? In other words could postgresql potentially return a cached
> value obtained from one client session to a different client session?

Return values from functions are never cached at all, not even for
immutable functions.  The mutability flag (currently) is only used for
deciding the "optimizability" of the function within the query's
execution.

-- 
Alvaro Herrera (<alvherre[a]surnet.cl>)
"El que vive para el futuro es un iluso, y el que vive para el pasado,
un imb├ęcil" (Luis Adler, "Los tripulantes de la noche")

In response to

pgsql-admin by date

Next:From: Michael FuhrDate: 2005-06-23 15:00:23
Subject: Re: Are cached IMMUTABLE values persistent between sessions
Previous:From: Tom LaneDate: 2005-06-23 14:33:03
Subject: Re: Are cached IMMUTABLE values persistent between sessions

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