Re: [GENERAL] function result cache for pl/pgsql

2007-10-24 Thread Peter Manchev
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 functio

[GENERAL] function result cache for pl/pgsql

2007-10-23 Thread Peter Manchev
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? I am not that familiar with th