X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D867652A50 for ; Thu, 24 Mar 2005 13:42:47 +0000 (GMT) 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 18964-04 for ; Thu, 24 Mar 2005 13:42:41 +0000 (GMT) Received: from sunsite.dcc.uchile.cl (sunsite.dcc.uchile.cl [192.80.24.2]) by svr1.postgresql.org (Postfix) with ESMTP id 4E90A53422 for ; Thu, 24 Mar 2005 13:42:40 +0000 (GMT) Received: from anakena.dcc.uchile.cl (anakena [192.80.24.6]) by sunsite.dcc.uchile.cl (8.12.11/8.12.11) with ESMTP id j2ODgefs022425; Thu, 24 Mar 2005 09:42:41 -0400 (CLT) Received: by anakena.dcc.uchile.cl (Postfix, from userid 4151) id 67AF852D0F; Thu, 24 Mar 2005 09:42:40 -0400 (CLT) Date: Thu, 24 Mar 2005 09:42:40 -0400 From: Alvaro Herrera To: Enrico Weigelt Cc: pgsql-performance@postgresql.org Subject: Re: clear function cache (WAS: SQL function inlining) Message-ID: <20050324134240.GD20726@dcc.uchile.cl> References: <7635.1111596928@sss.pgh.pa.us> <20050324133248.GB31203@nibiru.borg.metux.de> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <20050324133248.GB31203@nibiru.borg.metux.de> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.349 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE X-Spam-Level: X-Archive-Number: 200503/506 X-Sequence-Number: 11211 On Thu, Mar 24, 2005 at 02:32:48PM +0100, Enrico Weigelt wrote: > BTW: is it possible to explicitly clear the cache for immutable > functions ? What cache? There is no caching of function results. > I'd like to use immutable functions for really often lookups like > fetching a username by uid and vice versa. The queried tables > change very rarely, but when they change is quite unpredictable. Maybe you should use a stable function if you fear we'll having function result caching without you noticing. -- Alvaro Herrera () "Aprende a avergonzarte más ante ti que ante los demás" (Demócrito)