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

clear function cache (WAS: SQL function inlining)

From: Enrico Weigelt <weigelt(at)metux(dot)de>
To: pgsql-performance(at)postgresql(dot)org
Subject: clear function cache (WAS: SQL function inlining)
Date: 2005-03-24 13:32:48
Message-ID: 20050324133248.GB31203@nibiru.borg.metux.de (view raw or flat)
Thread:
Lists: pgsql-performance
* Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

<big_snip>

BTW: is it possible to explicitly clear the cache for immutable 
functions ?

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.


thx
-- 
---------------------------------------------------------------------
 Enrico Weigelt    ==   metux IT service

  phone:     +49 36207 519931         www:       http://www.metux.de/
  fax:       +49 36207 519932         email:     contact(at)metux(dot)de
  cellphone: +49 174 7066481
---------------------------------------------------------------------
 -- DSL ab 0 Euro. -- statische IP -- UUCP -- Hosting -- Webshops --
---------------------------------------------------------------------

In response to

Responses

pgsql-performance by date

Next:From: Alvaro HerreraDate: 2005-03-24 13:42:40
Subject: Re: clear function cache (WAS: SQL function inlining)
Previous:From: Gustavo Franklin Nóbrega - PlanaeDate: 2005-03-24 11:52:15
Subject: Re: CPU 0.1% IOWAIT 99% for decisonnal queries

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