Massive Multi-node setup with Postgres and BDR in Retail System

on YouTube ↗34m

" summary

Describes using PostgreSQL with BDR (Bidirectional Replication) to build a distributed, multi-node backend for a high-performance POS retail system. Explains why BDR was chosen over webservices for data collection and integration, and how it was implemented to present a single integrated database, simplify synchronization, and maintain transactional integrity across nodes.

AI-written summary · about

" chapters (9)

1. 0:00Start
2. 1:37Our Proud Clients
3. 2:22Background
4. 4:30Analysis
5. 5:35Solutions
6. 22:07Warning
7. 22:32Conclusion
8. 23:15Questions?
9. 27:06Implementation

" related talks

• 50mEvolution Of PostgreSQL Replication and High Availability (upto ~ 99.999%)Stacy Scoggins · PGConf NYC 2021
• 13mBuilding reliable infrastructure with PostgresAndrey Fleyta · PGConf India 2025
• 50mReplication based Multi-Master solutions and design patternsTom Kincaid · PostgresOpen Silicon Valley 2017
• 46mBig databases, many servers, data center or cloud - it's all here!Flavio Gurgel · Devoxx France 2021
• 55mHigh Availability with PostgreSQL and PacemakerShaun M. Thomas · Postgres Open 2012
• 42mPostgreSQL Distributed: Architectures & Best practicesMarco Slot · PostgreSQL Conference Europe 2023
• 38mPostgreSQL as a distributed computing platformMarco Slot · PostgresOpen Silicon Valley 2017
• 09mMulti-Region Replication & DR for Distributed Postgres in Azure Cosmos DBNik Larin · Azure Cosmos DB: Liftoff 2022