PostgreSQL Replication Conflicts: Avoiding Pitfalls

on YouTube ↗51m

" summary

Covers common replication conflicts in PostgreSQL streaming replication—such as replication lag, logical slots, lock and snapshot conflicts, and tablespace issues—and explains PostgreSQL internals behind those problems. Describes best practices and observability tools (monitoring/diagnostics) to prevent and troubleshoot replication-related failures.

AI-written summary · about

" chapters (13)

1. 0:00Start
2. 3:23Replication Issues - Overview • Reliable replication scheme requires: Optimal configuration
3. 4:47Presentation Outline
4. 17:10Synching Up • Synchronous Streaming Replication
5. 21:53Replication Configuration • Configuration Parameters Sending Server
6. 25:55What Conflicts? So primary server and readonly standby. How can we have conflicts?
7. 27:04Replication Issues?
8. 27:41Types of Replication Issues Faced
9. 32:34Replication: Lock Conflict
10. 34:09Lock Conflict-Code Flow
11. 44:07Replication: Snapshot Conflicts Primary Server Standby Server
12. 44:34Snapshot Conflicts-Code Flow Start XLog Processing
13. 45:56Closing Thoughts Always tune for workload. There is no single solution that fits

" related talks

• 42mPostgreSQL Replication Conflicts: Avoiding PitfallsHamid Quddus Akhtar · PGConf NYC 2022
• 48mPostgreSQL Replication: 20 Pitfalls and SolutionsJulian Markwort · PostgreSQL Conference Europe 2023
• 51mPostgreSQL Replication Conflicts: Avoiding PitfallsHamid Quddus Akhtar · Percona Live 2022
• 49mDebugging and Troubleshooting PostgreSQL Streaming ReplicationAleksey Lesovskiy · HighLoad++ 2017
• 49mPostgreSQL Replication - The Most Exciting Technology on EarthEdward Snajder · Open Source Bridge 2013
• 22mSecuring Postgres with streaming replicationJan Karremans · POSETTE: An Event for Postgres 2025
• 02h 26mTutorialDenish Patel · PGConf Silicon Valley 2015
• 52mNew Data Replication Technologies in PostgreSQLAleksandr Alekseev · HighLoad++ 2017