Towards full ACID distributed transaction support with Foreign Data Wrapper
Towards full ACID distributed transaction support with Foreign Data Wrapper
Schedule

Presented by:

B94a7d47b13352782b755c39e53a3a4d

Nikhil Sontakke

from Timescale

Nikhil is a Core PostgreSQL Database Tech Lead at Timescale. He has been a PostgreSQL community member for over 10+ years now. He’s submitted patches for features and bug fixes in various PostgreSQL releases.

At Timescale, he is focusing on the distributed multi-node Timescale offering and is helping to deliver multinode operational capabilities for TimescaleDB optimized for Timescale Cloud.

Download slides

PostgreSQL has Foreign Data Wrapper (FDW) functionality and it is a powerful feature to access distributed data from across heterogenous data stores. FDW became writable in PostgreSQL 9.3 and therefore PostgreSQL with FDW has potential to act as a distributed database supporting both distributed reads and writes.

However, one of the biggest missing pieces is transaction management for distributed transactions. Currently, atomicity and consistency of ACID properties are missing which are essential to achieve full ACID supported distributed transactions functionality. A few proposals have been proposed but they are still undergoing discussions.

This presentation talks about the current status of FDW and the problems regarding atomicity and isolation. The talk then moves on to introduce a few proposed solutions.

Date:
2020 February 28 - 15:00
Duration:
40 min
Room:
Grand Victoria 2
Conference:
PGConf India, 2020
Language:
Track:
Database Engine Developers
Difficulty:
Medium

Happening at the same time:

  1. Fault injection facility for PostgreSQL developers
    2. Start Time:
    2020 February 28 15:00

    Room:
    Grand Victoria 1