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
Last activity: Oct 29, 2024, 11:43 AM