View Single Post

   
  #2 (permalink)  
Old 04-15-2008, 10:51 PM
Richard Huxton
 
Posts: n/a
Default Re: pl/pgsql function result cache

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/ora.../o57plsql.html
>
> Is it possible to get pl/pgsql function result cache functionality
> into PostgreSQL real soon?


Well it's unlikely to be "real soon" since 8.3 is currently approaching
beta-test.

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

--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Reply With Quote