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

From Josh Berkus
Subject Re: pl/pgsql function result cache
Date
Msg-id 200709050832.42922.josh@agliodbs.com
Whole thread Raw
In response to Re: pl/pgsql function result cache  (Richard Huxton <dev@archonet.com>)
List pgsql-hackers
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 scheme for caching previously called functions, and there would be no way 
to make it performant for iterative execution due to needing to make a 
pgmemcached call to check for cached results with each execution.  

-- 
Josh Berkus
PostgreSQL @ Sun
San Francisco


pgsql-hackers by date:

Previous
From: Richard Huxton
Date:
Subject: Re: pl/pgsql function result cache
Next
From: Tom Lane
Date:
Subject: Re: HEAD build troubles, buildfarm misconfigurations