Schedule - FOSDEM PGDay 2016

Deciphering two phase commit

Date: 2016-01-29
Time: 11:30–12:20
Room: Hotel
Level: Intermediate

The need to scale out PostgreSQL is a reality, thanks to our hunger for data. Ensuring ACID properties in a distributed system is both exciting as well as challenging. Two phase commit protocol ensures consistency and durability of transactions that distribute across multiple nodes. The ongoing extensible transaction manager API work, several massively parallel systems built off PostgreSQL are some instances of implementing the protocol in PostgreSQL. In this talk we explain working of two phase commit in the context of PostgreSQL. How costly DDL/DML statements become, is there an opportunity to optimize this cost, what are the implications on crash recovery? These are some of the questions we aim to delve into.


Ashwin Agrawal
Asim Praveen