PostgreSQL Lock Conflicts

Database engineering course | @hnasr | ☕

ShareLock

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

The following commands acquire ShareLock Table lock

  1. CREATE INDEX

The following are table locks conflicting with ShareLock

  1. RowExclusiveLock
  2. ShareUpdateExclusiveLock
  3. ShareRowExclusiveLock
  4. ExclusiveLock
  5. AccessExclusiveLock