Conference Schedule - PGConf.EU 2015

Back

Unlocking the Postgres Lock Manager

Date: 2015-10-29
Time: 10:30 - 11:20
Room: Ballroom C+D
Level: Intermediate

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.

Speaker

Bruce Momjian