Re: named cache

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
>