News for hackers. Stuff that matters.
Re:New Features Coming in PostgreSQL 10 by foota on Saturday April 08, 2017 @07:24PM (#14069623)
How do you know when the change will affect the matview? I don't know the syntax for creating it off the top of my head, but imagine a materialized view limited to the top ten records of a table.
Re:New Features Coming in PostgreSQL 10 by pgaddict on Sunday April 09, 2017 @03:17PM (#14073868)
I assume there will be some limitations what matviews can be updated automatically/ incrementally. E.g. updatable views (regular, not materialized) have a range of such restrictions, see: https://www.postgresql.org/docs/devel/static/sql-createview....

Hopefully, some of those restrictions will disappear, because matviews are often used to store pre-aggregted data, so the restriction on GROUP BY would be unfortunate.