Sample Header Ad - 728x90

Does PostgreSQL have lock promotion or escalation?

2 votes
1 answer
407 views
We having this strange behaviour with ExclusiveLock in one of our database running PostgreSQL 13. I am not able to dig what leads to this lock as lock info is from a monitoring tool. From what I see from docs ExclusiveLock only acquired by refreshing materialised view, however we don't have any materialised views in our database. Bit of research I ended up in this blog https://blog.heroku.com/curious-case-table-locking-update-query and the case this guy shares similar to mine , as I can see a few RowExclusiveLock during this period and few queries updating same row concurrently. However I coudn't find any official docs on PostgreSQL behaviour on lock escalation just like other databases do. Does Postgres escalate lock in rare cases? What cases can lead to escalations?
Asked by goodfella (595 rep)
Oct 29, 2024, 04:14 AM
Last activity: Oct 29, 2024, 11:43 AM