PGLogical the logical replication for Postgresql
summary
A Postgres extension called PGLogical extension implements logical decoding-based replication for 9.4+ and aims to replace trigger-based tools; it ships as SQL extensions, uses replication sets for table grouping, supports operation and row/column filtering, sequences (subscriber ahead), and optional synchronous apply. Benchmarks show roughly 5x faster than trigger-based solutions though usually slower than physical streaming; initial sync uses COPY snapshot, big single transactions and automated failover remain limitations, and admin actions require superuser.
AI-written summary · about
chapters (18)
- 0:00Intro
- 0:18Whoami
- 2:45Logical Replication History
- 4:27Current Development
- 6:01Physical Streaming Replication
- 6:58Logical Streaming Replication
- 8:58pglogical
- 12:58Installation
- 14:54Replication Sets
- 20:38Table replication
- 22:00Sequences
- 25:11Monitoring
- 29:09DDL Replication
- 31:29Performance (pgbench)
- 33:48Caveats
- 36:48Column Filtering
- 40:05Row based Filtering
- 43:19Planned features
related talks
31mPast, Present, and Future: Logical Decoding and Replication in PostgreSQL
59mLogical Replication...LIVE!
53mThe journey towards active replication in PostgreSQL
42mlesser known Superpower of Postgres Logical Replication
56mLogical Replication of DDLs
44mThe journey towards active-active replication in PostgreSQL
54mUnderstanding Logical Decoding and Replication
38mA journey into postgresql logical replication