← recall

lock manager term

Postgres component tracking row/table locks

Postgres' lock manager has a fast path of 16 locks per backend; beyond that, it falls back to a shared-memory hash table. High lock contention can become a bottleneck even before queries are slow.

topics: databases, postgres

references:

• Postgres — Lock Management
• Citus — Lock manager bottleneck