PGCon2015 - final

PGCon 2015
The PostgreSQL Conference

Ashutosh Bapat
Day Talks - Day 4 - Friday - 2015-06-19
Room DMS 1160
Start time 14:00
Duration 00:45
ID 800
Event type Lecture
Track Scaling Out
Language used for presentation English

Transacting with foreign servers - Two's company, three is ...

Managing transactions involving multiple foreign servers.

PostgreSQL has Foreign Data Wrappers and they are writable too! Upcoming features like partitioning, foreign table inheritance and join-push down for foreign tables pave the path for sharding. One missing piece in the puzzle is the distributed transaction manager required to maintain the atomicity and consistency of transactions involving foreign servers. The presentation talks about the current status of such transactions and discusses the path forward towards distributed transaction manager.

Support for writable foreign tables was added in PostgreSQL 9.3. As of now, atomicity and consistency is guaranteed, when a transaction makes changes to at most a single foreign server. It fails to do so when changes are made to multiple foreign servers. In order to achieve atomicity and consistency of transactions involving multiple foreign servers, PostgreSQL needs to take up the role of a distributed transaction manager. The talk covers the current status of distributed transactions. It further explores protocol to drive distributed transactions and infrastructure necessary to overcome various hardware, software and network failures during a distributed transaction. It also covers the use cases like data federation and sharding.