PGCon2013 - Final Release

PGCon 2013
The PostgreSQL Conference

Kevin Grittner
Day Talks - Day 1 - 2013-05-23
Room MNT 202
Start time 10:00
Duration 01:00
ID 594
Event type Lecture
Track DBA
Language used for presentation English

PostgresSQL Concurrency

How to manage race conditions in database access

This talk will discuss the problems which can occur when multiple database transactions are accessing the same data in PostgreSQL, and the various approaches to managing those problems.

The Multi-Version Concurrency Control (MVCC) used in PostgreSQL allow better performance and concurrency than older Strict 2 Phased Locking (S2PL) techniques, but presents some challenges for handling race conditions. This talk will describe the nature of the problems which can be encountered and discuss alternatives for managing those problems. No one technique is best for all workloads, so the pros and cons of various techniques will be discussed, and benchmarks of various workloads using various techniques will be shown, to illustrate the trade-offs.