On Wed, 3 Sep 2003, Alvaro Herrera wrote:
> On Wed, Sep 03, 2003 at 06:18:40PM +1000, Gavin Sherry wrote:
>
> > As for materialised views, I cannot recall any discussion of this in the
> > recent past.
>
> Sorry, what is a materialized view? Is it something that you can do
> with CREATE TABLE AS, or it is more involved than that?
Under Oracle, materialised views can be regularly updated when view base
tables are updated. They're very useful for datawarehousing and reporting,
particularly on large data sets.
Though useful, they would be far from trivial to implement in Postgres.
g