Re: Materialized Views

From:
Subject: Re: Materialized Views
Date: ,
Msg-id: 056a01c61ab8$63b70040$6402a8c0@iwing
(view: Whole thread, Raw)
In response to: Materialized Views  (Michael Riess)
List: pgsql-performance

Tree view

Materialized Views  (Michael Riess, )
 Re: Materialized Views  (Frank Wiles, )
  Re: Materialized Views  (Michael Riess, )
 Re: Materialized Views  (<>, )

hi mike

> In particular I'm interested in a view which materializes whenever
> queried, and is invalidated as soon as underlying data is changed.

from the german pgsql list earlier last week:

http://jonathangardner.net/PostgreSQL/materialized_views/matviews.html

this seems to be pretty much what you want (except you'll have to update
everything yourself). would be really nice if pgsql supports this "in-house"

cheers,
thomas




pgsql-performance by date:

From: Mark Lewis
Date:
Subject: Re: Suspending SELECTs
From: "Craig A. James"
Date:
Subject: Re: Suspending SELECTs