On Thu, Sep 29, 2016 at 8:10 AM, Nguyễn Trần Quốc Vinh <ntquocv...@gmail.com > wrote:
> Dear, > > As it was recommended, we pushed our projects into github: > https://github.com/ntqvinh/PgMvIncrementalUpdate. > > 1) Synchronous incremental update > - For-each-row triggers are generated for all changing events on all > underlying tables. > > 2) Asynchronous (deferred) incremental update > - Triggers are generated for all changing events on all underlying tables > to collect all changed rows > - Other codes are generated for each matview-query to update the matview. > > We hope that our projects may be helpful for someone! > Very interesting. Does this support materialized views with recursive queries? What about left joins? (not) exists? Aggregates? Window functions? In reading up on the implementations in other databases, I was surprised by some of the limitations imposed by DB2 / Oracle / Sql Server. I'm trying to look through the code base to answer my questions, but it's large enough that it may be easier to just ask first.
