X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 33E51D1B553 for ; Thu, 9 Oct 2003 07:26:37 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 58908-03 for ; Thu, 9 Oct 2003 04:25:49 -0300 (ADT) Received: from pool.imt.com.ua (office.imt.com.ua [212.109.53.33]) by svr1.postgresql.org (Postfix) with ESMTP id 977FBD1B564 for ; Thu, 9 Oct 2003 04:25:44 -0300 (ADT) Received: from pool.imt.com.ua (localhost [127.0.0.1]) by pool.imt.com.ua (8.12.8p2/8.12.8) with ESMTP id h997PZ4r029986; Thu, 9 Oct 2003 10:25:36 +0300 (EEST) (envelope-from ant@imt.com.ua) Received: from localhost (ant@localhost) by pool.imt.com.ua (8.12.8p2/8.12.8/Submit) with ESMTP id h997PX1d029983; Thu, 9 Oct 2003 10:25:34 +0300 (EEST) (envelope-from ant@imt.com.ua) Date: Thu, 9 Oct 2003 10:25:33 +0300 (EEST) From: Andriy Tkachuk To: Tom Lane Cc: pgsql-performance@postgresql.org Subject: Re: IMMUTABLE function's flag do not work: 7.3.4, plpgsql In-Reply-To: <5442.1065651752@sss.pgh.pa.us> Message-ID: <20031009101121.S29282-100000@pool.imt.com.ua> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/259 X-Sequence-Number: 4007 On Wed, 8 Oct 2003, Tom Lane wrote: > Andriy Tkachuk writes: > > At second. calc_total() is immutable function: > > but it seems that it's not cached in one session: > > It's not supposed to be. but it's written id doc: IMMUTABLE indicates that the function always returns the same result when given the same argument values; that is, it does not do database lookups or otherwise use information not directly present in its parameter list. If this option is given, any call of the function with all-constant arguments can be immediately replaced with the function value. I meant that the result of calc_total() is not "immediately replaced with the function value" as it's written in doc, but it takes as long time as the first function call in the session (with the same arguments). Maybe i misunderstand something? Thank you, Andriy Tkachuk. http://www.imt.com.ua