Re: named cache
| От | Willy-Bas Loos |
|---|---|
| Тема | Re: named cache |
| Дата | |
| Msg-id | 1dd6057e0612010227o13f539c6wd2a1d62f7cb8399d@mail.gmail.com обсуждение исходный текст |
| Ответ на | named cache (Matthew Peter <survivedsushi@yahoo.com>) |
| Ответы |
Re: named cache
|
| Список | pgsql-general |
maybe you would find "materialized views" interesting.
http://www.google.com/search?q=materialized+view+postgresql
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 по дате отправления: