sraoss / pgsql-ivm

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

why outer join supports only simple equijoin and is not supported with aggregate #137

Open xcl961717684 opened 2 years ago

xcl961717684 commented 2 years ago

I read the paper "Efficient_Maintenance_of_Materialized_Outer-Join_Views" and your code, it is theoretically possible to support more join conditions, but you only support simple equivalence conditions. Do you take efficiency into consideration or do you have any special reasons?

And your inner join with aggregate worked out perfectly,but outer join is not supported with aggregate. Is there any technical difficulty here? Can you tell me your consideration?