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