Re: pl/pgsql function result cache

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: pl/pgsql function result cache
Date: 2007-09-05 15:32:42
Message-ID: 200709050832.42922.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-09-05 16:01:48 Re: HEAD build troubles, buildfarm misconfigurations
Previous Message Richard Huxton 2007-09-05 15:17:01 Re: pl/pgsql function result cache