Re: Materialized views WIP patch - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: Materialized views WIP patch
Date
Msg-id 1353022537.14335.26.camel@sussancws0025
Whole thread Raw
In response to Materialized views WIP patch  ("Kevin Grittner" <kgrittn@mail.com>)
Responses Re: Materialized views WIP patch  (Dimitri Fontaine <dimitri@2ndQuadrant.fr>)
List pgsql-hackers
On Wed, 2012-11-14 at 21:28 -0500, Kevin Grittner wrote:
> Attached is a patch that is still WIP but that I think is getting
> pretty close to completion. It is not intended to be the be-all and
> end-all for materialized views, but the minimum useful feature set --
> which is all that I've had time to do for this release. In
> particular, the view is only updated on demand by a complete rebuild.
> For the next release, I hope to build on this base to allow more
> eager and incremental updates, and perhaps a concurrent batch update.

The documentation says that a materialized view is basically a
create-table-as-select except that it remembers the query. Would you say
that there is a compelling use case for this alone, or is this a
building block for more sophisticated materialized view support (e.g.
eager updating) later?

Regards,Jeff Davis




pgsql-hackers by date:

Previous
From: Craig Ringer
Date:
Subject: Re: another idea for changing global configuration settings from SQL
Next
From: Noah Misch
Date:
Subject: Re: Move postgresql_fdw_validator into dblink