PGCon2013 - Final Release
PGCon 2013
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Kevin Grittner |
| Schedule | |
|---|---|
| Day | Talks - Day 1 - 2013-05-23 |
| Room | MNT 202 |
| Start time | 10:00 |
| Duration | 01:00 |
| Info | |
| 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.