Re: pl/pgsql function result cache

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: pl/pgsql function result cache
Дата
Msg-id 200709050832.42922.josh@agliodbs.com
обсуждение исходный текст
Ответ на Re: pl/pgsql function result cache  (Richard Huxton <dev@archonet.com>)
Список 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 по дате отправления:

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: pl/pgsql function result cache
Следующее
От: Tom Lane
Дата:
Сообщение: Re: HEAD build troubles, buildfarm misconfigurations