Re: Function result cacheing - any comments? - Mailing list pgsql-hackers

From Philip Warner
Subject Re: Function result cacheing - any comments?
Date
Msg-id 5.1.0.14.0.20020819173248.036667b0@mail.rhyme.com.au
Whole thread Raw
In response to Re: Function result cacheing - any comments?  (Gavin Sherry <swm@linuxworld.com.au>)
Responses Re: Function result cacheing - any comments?  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-hackers
At 17:03 19/08/2002 +1000, Gavin Sherry wrote:

>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.

Exactly. But obviously not limited to simple mathematical functions.




----------------------------------------------------------------
Philip Warner                    |     __---_____
Albatross Consulting Pty. Ltd.   |----/       -  \
(A.B.N. 75 008 659 498)          |          /(@)   ______---_
Tel: (+61) 0500 83 82 81         |                 _________  \
Fax: (+61) 0500 83 82 82         |                 ___________ |
Http://www.rhyme.com.au          |                /           \|                                 |    --________--
PGP key available upon request,  |  /
and from pgp5.ai.mit.edu:11371   |/



pgsql-hackers by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: Re: Function result cacheing - any comments?
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Re: Function result cacheing - any comments?