Re: memcached and PostgreSQL - Mailing list pgsql-performance

From Greg Stark
Subject Re: memcached and PostgreSQL
Date
Msg-id 87y8h06gp7.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: memcached and PostgreSQL  (Josh Berkus <josh@agliodbs.com>)
Responses Re: memcached and PostgreSQL
List pgsql-performance
Josh Berkus <josh@agliodbs.com> writes:

> So memcached becomes a very good place to stick data that's read often but not
> updated often, or alternately data that changes often but is disposable.   An
> example of the former is a user+ACL list; and example of the latter is web
> session information ... or simple materialized views.

I would like very much to use something like memcached for a materialized view
I have. The problem is that I have to join it against other tables.

I've thought about providing a SRF in postgres to read records out of
memcached but I'm unclear it would it really help at all.

Has anyone tried anything like this?

--
greg

pgsql-performance by date:

Previous
From: Troels Arvin
Date:
Subject: Re: memcached and PostgreSQL
Next
From: Kris Jurka
Date:
Subject: Re: mis-estimation on data-warehouse aggregate creation