On 11/6/2017 10:38 PM, 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.
you refresh a materialized view with REFRESH MATERIALIZED VIEW name;
There's no 'incremental' methods, as views can be quite complex.
I do not know what you mean by 'materialized view log', is this a
feature of some other database server ?
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general