| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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 --
---------------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2005-03-24 13:42:40 | Re: clear function cache (WAS: SQL function inlining) |
| Previous Message | Gustavo Franklin Nóbrega - Planae | 2005-03-24 11:52:15 | Re: CPU 0.1% IOWAIT 99% for decisonnal queries |