What exactly are the features you are looking for? Materialized views are treated as tables in PostgreSQL and you can create indexes on them.
https://www.postgresql.org/docs/9.4/static/sql-creatematerializedview.html "CREATE MATERIALIZED VIEW is *similar to **CREATE TABLE* AS, except that it also remembers the query used to initialize the view, so that it can be refreshed later upon demand. *A materialized view has many of the same properties as a table*, but there is no support for temporary materialized views or automatic generation of OIDs." On Sat, Dec 3, 2016 at 8:55 AM, inspector morse <inspectormors...@gmail.com> wrote: > Is there any work being done on materialized views for version 9.7? This > postgresql feature is severely lacking compared to similar features like > indexed views by sql server. > > > -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.
