Schedule - PGConf.EU 2011
Serializable Snapshot Isolation
Before PostgreSQL 9.1, serializable isolation level was not in fact fully serializable, as the SQL specification intended. 9.1 introduces a new feature called Serializable Snapshot Isolation, which fixes that. In this presentation, I will explain the anomalies that can occur without Serializable Snapshot Isolation, how SSI avoids them, and what you need to know about SSI when developing applications on PostgreSQL.