| From: | "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | "Peter Manchev" <pmanchev(at)hotmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: function result cache for pl/pgsql |
| Date: | 2007-10-24 06:22:41 |
| Message-ID: | 162867790710232322u364db78dl4a1f21bc9e3c14f7@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
2007/10/24, Peter Manchev <pmanchev(at)hotmail(dot)com>:
>
> I was thinking about pl/pgsql and comparing it with pl/sql function result cache,
> featured in Oracle 11g - see
>
> http://www.oracle.com/technology/oramag/oracle/07-sep/o57plsql.html
>
> Is it possible to get pl/pgsql function result cache functionality into PostgreSQL?
plpgsql doesn't allow access to shared memory now. You can use plper
for caching some resuts. I am not sure if result cache is generally
accaptable technique, but I thing, I can write similar functionality
for orafce
if you need anything hurry, use plperl
http://www.postgresql.org/docs/8.2/interactive/plperl-global.html and
$_SHARED array.
Regards
Pavel Stehule
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tommy Gildseth | 2007-10-24 06:36:30 | Re: (Never?) Kill Postmaster? |
| Previous Message | Ow Mun Heng | 2007-10-24 06:15:50 | Re: (Never?) Kill Postmaster? |