X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4C6F252939 for ; Thu, 23 Jun 2005 11:41:15 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 53223-10 for ; Thu, 23 Jun 2005 14:41:10 +0000 (GMT) Received: from mr2.surnet.cl (smtp2.surnet.cl [216.155.73.163]) by svr1.postgresql.org (Postfix) with ESMTP id 926C55293C for ; Thu, 23 Jun 2005 11:41:10 -0300 (ADT) Received: from smtp2.surnet.cl (216.155.73.169) by mr2.surnet.cl (7.0.031.3) id 4259ADFA01078F2F; Thu, 23 Jun 2005 10:40:57 -0400 Received: from smtp2.surnet.cl (mr2.surnet.cl []) by mr2.surnet.cl ([216.155.73.169]); Thu, 23 Jun 2005 14:40:57 +0000 Received: from cluster.surnet.cl (216.155.73.164) by smtp2.surnet.cl (7.0.031.3) id 4259ADE3009D39E7; Thu, 23 Jun 2005 10:40:56 -0400 Received: from localhost (200.85.219.179) by cluster.surnet.cl (7.0.043) id 42B3EF60000BACE8; Thu, 23 Jun 2005 10:40:54 -0400 Received: by localhost (Postfix, from userid 1000) id 32B0DC2956C; Thu, 23 Jun 2005 10:40:55 -0400 (CLT) Date: Thu, 23 Jun 2005 10:40:55 -0400 From: Alvaro Herrera To: Donald Fraser Cc: "[ADMIN]" Subject: Re: Are cached IMMUTABLE values persistent between sessions Message-ID: <20050623144055.GC7656@surnet.cl> References: <002301c577f7$28141780$6364a8c0@DonAcer> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <002301c577f7$28141780$6364a8c0@DonAcer> User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.584 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, FORGED_RCVD_HELO X-Spam-Level: * X-Archive-Number: 200506/169 X-Sequence-Number: 17924 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 () "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")