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

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

2007-10-23 Thread Pavel Stehule
2007/10/24, Peter Manchev <[EMAIL PROTECTED]>: > > 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 fun

[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