Re: pl/pgsql function result cache - Mailing list pgsql-hackers

From Richard Huxton
Subject Re: pl/pgsql function result cache
Date
Msg-id 46DEC86D.1080003@archonet.com
Whole thread Raw
In response to pl/pgsql function result cache  (Peter Manchev <pmanchev@hotmail.com>)
Responses Re: pl/pgsql function result cache
List pgsql-hackers
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?

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


pgsql-hackers by date:

Previous
From: Peter Manchev
Date:
Subject: pl/pgsql function result cache
Next
From: Josh Berkus
Date:
Subject: Re: pl/pgsql function result cache