PostgreSQL Lock Conflicts

Database engineering course | @hnasr | ☕

RowExclusiveLock

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

The following commands acquire RowExclusiveLock Table lock

  1. INSERT
  2. UPDATE (NO KEYS)
  3. UPDATE (KEYS)
  4. DELETE
  5. COPY FROM
  6. MERGE

The following are table locks conflicting with RowExclusiveLock

  1. ShareLock
  2. ShareRowExclusiveLock
  3. ExclusiveLock
  4. AccessExclusiveLock