2010/6/29 David Christensen <david@endpoint.com>:
> Do we see supporting the creation of a materialized view from a regular view, as in ALTER VIEW regular_view SET
MATERIALIZEDor some such?
I'm not sure. I think we should focus our efforts on (1) getting it
to work at all and then (2) improving the performance of the refresh
operation, which will doubtless be pessimal in the initial
implementation. Those are big enough problems that I'm not inclined
to spend much thought on bells and whistles at this point.
> Since we're treating this as a distinct object type, instead of repeatedly typing "MATERIALIZED VIEW", is there a
possibilityof introducing a keyword alias "MATVIEW" without complicating the grammar/code all that much, or is that
frownedupon? Paintbrushes, anyone?
-1 from me, but IJWH.
By the way, does the SQL standard say anything about materialized views?
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company