Postgres Pro
Downloads
Home   >   mailing lists

Re: named cache - Mailing list pgsql-general

From Willy-Bas Loos
Subject Re: named cache
Date
Msg-id 1dd6057e0612010227o13f539c6wd2a1d62f7cb8399d@mail.gmail.com
Whole thread Raw
In response to named cache  (Matthew Peter <survivedsushi@yahoo.com>)
Responses Re: named cache  (Matthew Peter <survivedsushi@yahoo.com>)
List pgsql-general
Tree view
maybe you would find "materialized views" interesting.
http://www.google.com/search?q=materialized+view+postgresql


On 12/1/06, Matthew Peter <survivedsushi@yahoo.com> 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.



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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

pgsql-general by date:

Previous
From: veejar
Date:
Subject: Restoring database from files on disk
Next
From: Arnaud Lesauvage
Date:
Subject: COPY FROM and NULL AS does not work