PostgreSQL Lock Conflicts

Database engineering course | @hnasr |

FORKEYSHARE

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

The following commands acquire FORKEYSHARE Row lock

  1. SELECT FOR KEY SHARE

The following are row locks conflicting with FORKEYSHARE

  1. FORUPDATE