Schedule - PGConf.EU 2015
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.
