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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
