What?

Locking is a mechanism used to prevent concurrent access to shared resources such as table, rows, and transactions.

  • Data consistency and integrity

PostgreSQL supports several types of locks

  • shared locks
  • exclusive locks
  • advisory locks

Shared locks