Lock

A mechanism preventing concurrent access conflicts. PostgreSQL uses multiple lock types: row-level (shared/exclusive), table-level (eight modes from ACCESS SHARE to ACCESS EXCLUSIVE), advisory, and predicate locks.