Presented by:

B94a7d47b13352782b755c39e53a3a4d

Nikhil Sontakke

from 2ndQuadrant

Nikhil is a Postgresql Consultant at 2ndQuadrant. 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. Earlier, he was a Technical Architect and Founding Member at StormDB which was merged into Translattice to focus on their PostgreSQL based geo-distributed database offering.

At 2ndQuadrant he is focusing on contributing to the BDR and 2ndQPostgres projects, along with various other customer facing activities.

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