sraoss / pg_ivm

IVM (Incremental View Maintenance) implementation as a PostgreSQL extension
Other
854 stars 24 forks source link

Use exclusive lock for view maintenance caused by UPDATE or DELETE #42

Closed yugo-n closed 1 year ago

yugo-n commented 1 year ago

When using DELETE or UPDATE, we must use exclusive lock for now because apply_old_delta(_with_count) could result in wrong results with concurrent transactions. We would like to improve it in future, but we prevent it by using the lock for now.