named cache - Mailing list pgsql-general

From Matthew Peter
Subject named cache
Date
Msg-id 730100.40715.qm@web35215.mail.mud.yahoo.com
Whole thread Raw
Responses Re: named cache  (Richard Huxton <dev@archonet.com>)
Re: named cache  ("Willy-Bas Loos" <willybas@gmail.com>)
List pgsql-general
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.



____________________________________________________________________________________
Cheap talk?
Check out Yahoo! Messenger's low PC-to-Phone call rates.
http://voice.yahoo.com

pgsql-general by date:

Previous
From: Teodor Sigaev
Date:
Subject: Re: Tsearch2 - Error using tsquery object in GROUP BBY
Next
From: Henrik Zagerholm
Date:
Subject: Re: Tsearch2 - Error using tsquery object in GROUP BBY