| From: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | "Gavin Sherry" <swm(at)linuxworld(dot)com(dot)au>, "Joe Conway" <mail(at)joeconway(dot)com> |
| Cc: | "Philip Warner" <pjw(at)rhyme(dot)com(dot)au>, <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Function result cacheing - any comments? |
| Date: | 2002-08-19 07:18:14 |
| Message-ID: | GNELIHDDFBOCMGBFGEFOGEMDCDAA.chriskl@familyhealth.com.au |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> What Philip seems to be asking for is a mechanism where by if a function
> is marked as being mathematically deterministic (given a particular set of
> parameters the same result is always returned -- eg: cos(), sin(),
> etc) then the result is cached and next time the function is called with
> the same argument(s) the result is retrieved from the cache instead of the
> function being run again.
I was under the impression that the sin, cos, tan and like functions are
marked non-volatile in the system catalogs and so are evaluated once per
transaction only.
Chris
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Philip Warner | 2002-08-19 07:34:22 | Re: Function result cacheing - any comments? |
| Previous Message | Gavin Sherry | 2002-08-19 07:03:18 | Re: Function result cacheing - any comments? |