September 14-16, 2011

Westin Michigan Avenue Hotel, Chicago

Log in or Sign Up

Unlocking the Postgres Lock Manager

log in to bookmark this presentaton

Experienced / Talk
September 16th 9:10 a.m. – 10:10 a.m.
Locking is critical for providing high concurrency for any database --- you can't 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.

Abstract

Locking is critical for providing high concurrency for any database --- you can't 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. The talk will include analysis of locking on a running system.