PGCon2012 - Slide release #12

PGCon 2012
The PostgreSQL Conference

Speakers
Bruce Momjian
Schedule
Day Talks - 1 - Thursday - 2012-05-17
Room MRT 218
Start time 14:30
Duration 01:00
Info
ID 454
Event type Lecture
Track Advanced Features
Language used for presentation English
Feedback

Unlocking the Postgres Lock Manager

Locking is critical for providing high concurrency for any database — you cannot fully utilize your hardware if locking is throttling its use. This talk explores all aspects of locking in Postgres by showing queries and their locks; covered lock types include row, table, shared, exclusive, and advisory lock types. The high concurrency provided by Multiversion Concurrency Control (MVCC) is also covered.

Locking is critical for providing high concurrency for any database — you cannot fully utilize your hardware if locking is throttling its use. This talk explores all aspects of locking in Postgres by showing queries and their locks; covered lock types include row, table, shared, exclusive, and advisory lock types. The high concurrency provided by Multiversion Concurrency Control (MVCC) is also covered.