Re: pl/pgsql function result cache

From: Richard Huxton <dev(at)archonet(dot)com>
To: Peter Manchev <pmanchev(at)hotmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: pl/pgsql function result cache
Date: 2007-09-05 15:17:01
Message-ID: 46DEC86D.1080003@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Josh Berkus 2007-09-05 15:32:42 Re: pl/pgsql function result cache
Previous Message Chris Browne 2007-09-05 15:11:31 Re: Lazy xid assignment V4