From: | "Willy-Bas Loos" <willybas(at)gmail(dot)com> |
---|---|
To: | "Matthew Peter" <survivedsushi(at)yahoo(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: named cache |
Date: | 2006-12-01 10:27:25 |
Message-ID: | 1dd6057e0612010227o13f539c6wd2a1d62f7cb8399d@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
maybe you would find "materialized views" interesting.
http://www.google.com/search?q=materialized+view+postgresql
On 12/1/06, Matthew Peter <survivedsushi(at)yahoo(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Arnaud Lesauvage | 2006-12-01 10:28:23 | COPY FROM and NULL AS does not work |
Previous Message | veejar | 2006-12-01 10:24:54 | Restoring database from files on disk |