Understanding Locking and Concurrency in PostgreSQL
Understanding Locking and Concurrency in PostgreSQL
Speaker: Pavan Deolasee (EDB)
🔗 https://live.pgconf.in/events/pgconf-...
PGConf India 2026 — Asia's Premier PostgreSQL Conference
March 11-13, 2026 | Sheraton Grand Hotel, Bangalore
https://pgconf.in
---
This session takes a deep dive into how PostgreSQL manages concurrent access through its sophisticated locking and concurrency control mechanisms. We’ll start by understanding why locks exist in the first place, how they ensure data consistency when multiple clients read and modify the same data, and then explore the main types of locks at both the row and table level. You’ll learn how the lock manager coordinates access, what happens internally when locks conflict, and how PostgreSQL detects and resolves deadlocks.
We’ll also examine the relationship between locks, transactions, and isolation levels, and how choices here can influence contention and performance. Through clear examples and queries against system catalog views like pg_locks and pg_stat_activity, you’ll see how to identify blocking sessions, interpret lock wait events, and diagnose bottlenecks in your own workload.
Finally, we’ll cover practical techniques for avoiding unnecessary locking issues — from careful transaction design to query patterns and index strategies that minimize contention. Whether you’re a developer, DBA, or curious PostgreSQL user, this talk will help you gain the confidence to keep your database running smoothly, even under high concurrency.
En esta página del sitio puede ver el video en línea Understanding Locking and Concurrency in PostgreSQL de Duración hora minuto segunda en buena calidad , que subió el usuario PGConf India 24 marzo 2026, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 72 veces y le gustó 0 a los espectadores. Disfruta viendo!
