named cache

From: Matthew Peter <survivedsushi(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: named cache
Date: 2006-12-01 09:01:54
Message-ID: 730100.40715.qm@web35215.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Henrik Zagerholm 2006-12-01 09:18:11 Re: Tsearch2 - Error using tsquery object in GROUP BBY
Previous Message Teodor Sigaev 2006-12-01 08:56:23 Re: Tsearch2 - Error using tsquery object in GROUP BBY