On Thu, Sep 29, 2016 at 8:10 AM, Nguyễn Trần Quốc Vinh <ntquocvinh@xxxxxxxxx> 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.
