Thomas Kellerer <spam_eater@xxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general