Re: [GENERAL] Incremental refresh - Materialized view

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