Krithika Venkatesh wrote: > I need to implement incremental refresh of materialized view. > > Please let me know how to do the incremental refresh of materialized view in > postgresql 9.5.9 version. > > Is there anything similar to materialized view log in postgresql.
There is no such feature in PostgreSQL (yet), so you'll have to do it yourself. The "materialized view" would then be a regular table (with read only access), and each underlying table would have a trigger that records changes with a timestamp to a log table. You can then write a function that brings the "materialized view" up to date. Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
