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
