PGCon2013 - Final Release

PGCon 2013
The PostgreSQL Conference

Andres Freund
Day Talks - Day 1 - 2013-05-23
Room MRT 221
Start time 11:30
Duration 01:00
ID 577
Event type Lecture
Track Hacking
Language used for presentation English

On the road to in-core logical replication!? Part 1: Architecture of Changeset Extraction

Logical Replication in the context of postgres to this date consists out of several independent out-of-core solutions. While some of these solutions are great, the existance of many of those also causes problems like code duplication, lack of trust, features, reliability and peformance.

As part of a proposal to include one logical replication solution into core postgresql we submitted the changeset generation/extraction part as a core infrastructure to postgres. In a way its usable by all the existing replication solutions and for lots of other usecases.

This talk is about:

  • the architecture of the committed/proposed changeset generation mechanism (2/3)
  • An overview over further proposed patches (9.4+) to get a whole logical replication into core postgres (1/3)