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.
Nesta página do site você pode assistir ao vídeo on-line Understanding Locking and Concurrency in PostgreSQL duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário PGConf India 24 Março 2026, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 72 vezes e gostou 0 espectadores. Boa visualização!
