Re: 9.3 beta and materialized views - Mailing list pgsql-general

From Kevin Grittner
Subject Re: 9.3 beta and materialized views
Date
Msg-id 1368727174.83283.YahooMailNeo@web162901.mail.bf1.yahoo.com
Whole thread Raw
In response to Re: 9.3 beta and materialized views  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-general
Thomas Kellerer <spam_eater@gmx.net> wrote:
> Tom Lane wrote on 16.05.2013 19:36:

>>> As the materialized view should be a "table" that can be
>>> selected from, I wonder what the purpose of the rewrite rule
>>> is?
>>
>> To store the matview's definition for use in REFRESH.
>>
> Ah, right. Makes sense.

It will also be used to drive incremental update (in future
releases), as it does in every other product with materialized
views that I know of.  In 9.3 we only got as far as explicit
REFRESH, but I hope to improve on that in 9.4.

--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-general by date:

Previous
From: AI Rumman
Date:
Subject: Re: pg_upgrade link mode
Next
From: Igor Neyman
Date:
Subject: Re: pg_upgrade link mode