PostgreSQL Lock Conflicts

Database engineering course | @hnasr | ☕

ExclusiveLock

The ExclusiveLock lock is a Table lock. This list shows the commands that acquire ExclusiveLock and what locks conflicts with it.

The following commands acquire ExclusiveLock Table lock

  1. REFRESH MATERIALIZED VIEW CONCURRENTLY

The following are table locks conflicting with ExclusiveLock

  1. RowShareLock
  2. RowExclusiveLock
  3. ShareUpdateExclusiveLock
  4. ShareLock
  5. ShareRowExclusiveLock
  6. ExclusiveLock
  7. AccessExclusiveLock