| From: | Peter Manchev <pmanchev(at)hotmail(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: function result cache for pl/pgsql |
| Date: | 2007-10-24 15:37:08 |
| Message-ID: | BAY139-W750455006D5FE87228885C5940@phx.gbl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
IMHO, pl/perl;s global hash %_SHARED does not provide the same performance.
With pl/perl with some data cached we will get getter performance, that is sure, but the body of the function will be evaluated anyway, so there will be some miliseconds lost.
On the other hand, the body of a function with in-memory result cache clause will not be evaluated if the supplied arguments' result is already cached, and the function will just instantly return the result - which is the timesaver.
So, I would prefer to have such function clause implemented in pgsql, maybe as add-on.
Best,
Peter
_________________________________________________________________
Peek-a-boo FREE Tricks & Treats for You!
http://www.reallivemoms.com?ocid=TXT_TAGHM&loc=us
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Erik Jones | 2007-10-24 15:41:05 | Re: google |
| Previous Message | brian | 2007-10-24 15:17:54 | Re: Automating Backup & Restore |