The anatomy of PostgreSQL row locks
October 20–23
Level: Intermediate
Everybody knows about row locks, right? They prevent conflicts between data modifications, and you take them with UPDATE, DELETE and SELECT ... FOR UPDATE.
This talk shows that there is much more to know about row locks:
- What lock levels are there and what is their purpose?
- How does PostgreSQL use row locks to maintain foreign key consistency?
- How are row locks stored and how are they taken?
- How can you inspect row locks?
- How do row locks look in
pg_locks? - What the heck is a "MultiXact", and what is the connection with row locks?
If you administrate or develop a highly transactional PostgreSQL database, you should know about these things.
