Re: [HACKERS] pl/pgsql function result cache

2007-09-05 Thread Josh Berkus
Richard, > Surely memcached+pgmemcache does basically this anyway, except: > - it's not restricted to function outputs > - you can cache application objects > - you can spread your cache across multiple machines Sure, but using memcached is far from automatic ... you'd have to roll your own sche

Re: [HACKERS] pl/pgsql function result cache

2007-09-05 Thread Richard Huxton
Peter Manchev wrote: 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 real soon?

[HACKERS] pl/pgsql function result cache

2007-09-05 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 real soon? Best, Peter _