Scalability, Consistency, Replication, Availability and Performance
summary
Claims that logical decoding lands in 9.4 and a BDR prototype supports 48 nodes tested with near-physical-replication throughput (about a 5–10% throughput drop versus physical), plus features: efficient change capture and low-level apply, transparent global sequences, mid-stream DDL replication, automatic conflict resolution (default last-update-wins with conflict triggers), UDR as a stock-9.4 extension, online upgrade tooling toward 9.5, and no general write-scalability yet.
AI-written summary · about
chapters (8)
- 0:00Start
- 1:11start off with a little bit of thinking at the beginning
- 24:45run workloads on multiple nodes
- 26:29upgrade databases between major versions
- 28:03supporting a single open source version of postgresql
- 36:18building logical replication on top of logical decoding
- 41:32log conflicts to a table
- 43:48log your conflicts to a table
related talks
50mEvolution Of PostgreSQL Replication and High Availability (upto ~ 99.999%)
31mPast, Present, and Future: Logical Decoding and Replication in PostgreSQL
53mThe journey towards active replication in PostgreSQL
47mDatabase Resiliency
27mAvailability and Performance Tradeoffs in Global Database Deployments
48mReplication Refresh
34mMassive Multi-node setup with Postgres and BDR in Retail System
42mlesser known Superpower of Postgres Logical Replication