sraoss / pgsql-ivm

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

Use exclusive lock always at the incremental maintenance #154

Closed yugo-n closed 1 year ago

yugo-n commented 1 year ago

We must use exclusive lock for now because apply_old_delta(_with_count) doesn't work in concurrent situations. If the view doesn't have aggregate, distinct, or tuple duplicate, then it would work. However, we don't have any way to guarantee the view has a unique key before opening the IMMV at the maintenance time because users may drop the unique index.

We need something to resolve the issue!! (#148)