search

sraoss / pgsql-ivm

IVM (Incremental View Maintenance) development for PostgreSQL
Other
129 stars 12 forks source link

IVM is not worked correctly when use logical replication. #10

Open thoshiai opened 5 years ago

thoshiai commented 5 years ago

Currently, IVM use statement trigger. If base table is used by logical replicatoin, subscriber side can not work statemnet trigger.

When publicher's change is replicated to subscriber, statement trigger don't execute normally on subscriber side. So incremental view maintenance don't work well on subscriver side.