hard20 pts · first answer countstransactionspostgresqlrow-locks
Many share locks on one row
Thousands of child inserts lock the same parent row with FOR KEY SHARE at the same time. Where does PostgreSQL keep the list of lockers?
Discussion 0
Join free to post in the discussion.
Related questions
- Durability in ACIDDatabase Administrator
- Logical vs physical backupDatabase Administrator
- Why a write-ahead log existsDatabase Administrator
- Read-only access for analystsDatabase Administrator
- What pg_hba.conf controlsDatabase Administrator
- View vs materialized viewDatabase Administrator
- What ROLLBACK undoesDatabase Administrator
- Seeing what is running nowDatabase Administrator