Re: named cache

Matthew Peter wrote:
> Is it possible to put an query result into memory? Like SELECT * from table WHERE
> [...] CACHE cache_name TIMEOUT '1 hour'::interval; So if "cache_name" exists with
> the same SQL statement, the result would be fetched from the cache, refreshing and
> updating the cache with fresh results when it expires? Reducing disk reads, query
> times, etc.

No. That's not something PG does internally.

Sounds like you might want to look at memcached/pgmemcached.

--
   Richard Huxton
   Archonet Ltd