Logical replication | Postgres.FM 063 |

[ 🇬🇧_🇺🇸 Check out the subtitles - we now edit them, ChatGPT+manually! You can also try RUclips's auto-translation of them from English to your language; try it and share it with people interested in Postgres!]
Nikolay and Michael discuss logical replication - some history, initialization, change data capture, how to scale it, some limitiations, and ways that it is getting better.
Here are some links to some things they mentioned:
Logical replication www.postgresql...
GitLab upgraded multi-terabyte, heavily-loaded clusters with zero-downtime / 1700574156222505276
pg_waldump www.postgresql...
pg_dump and external snapshots (blog post by Michael Paquier) paquier.xyz/po...
Failover of logical replication slots in Patroni (talk by Alexander Kukushkin) • Alexander Kukushkin. F...
Our episode on replication postgres.fm/ep...
~~~
What did you like or not like? What should we discuss next time? Let us know in the comments, or by tweeting us on @samokhvalov / samokhvalov and @michristofides / michristofides
~~~
Postgres FM is brought to you by:
Nikolay Samokhvalov, founder of Postgres.ai postgres.ai/
Michael Christofides, founder of pgMustard pgmustard.com/
~~~
This is the uncut version, with video. Check out Postgres.fm to find audio-only podcast episodes, edited for convenient listening.

[@swapnilsolanki8595]

This channel is gonna become huge in near future🔥

[@iury0x58]

Thank you for this content. Very nice

[@LearningSFR]

Awesome work. I would love to hear more about logical replication on high intensive workloads (master node with hundreds of databases x 1 replication slot per database)

[@mehrdadnafisi9233]

Very informative. Thanks