Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id C26D4475E26 for ; Tue, 15 Oct 2002 04:45:12 -0400 (EDT) Received: from anchor-post-32.mail.demon.net (anchor-post-32.mail.demon.net [194.217.242.90]) by postgresql.org (Postfix) with ESMTP id 1D313475E20 for ; Tue, 15 Oct 2002 04:45:12 -0400 (EDT) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-32.mail.demon.net with esmtp (Exim 3.35 #1) id 181NKA-000C3d-0W; Tue, 15 Oct 2002 09:45:13 +0100 Received: from localhost (localhost.localdomain [127.0.0.1]) by mainbox.archonet.com (Postfix) with ESMTP id CEE561736B; Tue, 15 Oct 2002 09:18:16 +0100 (BST) Received: from client.archonet.com (client.archonet.com [192.168.1.16]) by mainbox.archonet.com (Postfix) with ESMTP id 275BA17341; Tue, 15 Oct 2002 09:18:16 +0100 (BST) Content-Type: text/plain; charset="iso-8859-1" From: Richard Huxton Organization: Archonet Ltd To: Tom Lane Subject: Re: Stored procedure returning row or resultset Date: Tue, 15 Oct 2002 09:17:26 +0100 User-Agent: KMail/1.4.3 Cc: pgsql-sql@postgresql.org References: <200210141622.54638.heiko.stoermer@login-solutions.de> <200210141605.04208.dev@archonet.com> <17131.1034615852@sss.pgh.pa.us> In-Reply-To: <17131.1034615852@sss.pgh.pa.us> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200210150917.26662.dev@archonet.com> X-Virus-Scanned: by AMaViS snapshot-20020531 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/154 X-Sequence-Number: 9871 On Monday 14 Oct 2002 6:17 pm, Tom Lane wrote: > Richard Huxton writes: > > Have you looked at marking f1() etc cachable? This means Postgresql > > will only call the function once for each parameter-set. > > Unfortunately that's not true at all, or at least not helpful for this > problem. The cachable attribute was poorly named, because it leads > people to think that PG *will* cache function results, as opposed to > *could* cache function results. I must admit, that was my impression. Are there simple rules for if/when PG= =20 will cache function results? --=20 Richard Huxton