Locking in PostgreSQL deep dive

Last updated Feb 27, 2023

• Postgresql
• Database

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

• Data consistency and integrity

• shared locks
• exclusive locks
• advisory locks