[ 🇬🇧_🇺🇸 Check out the subtitles - we now edit them, ChatGPT+manually! You can also try KZread's auto-translation of them from English to your language; try it and share it with people interested in Postgres!]
Nikolay and Michael are joined by Sai Srirampur, CEO and Co-founder of PeerDB, to discuss how to overcome several logical replication issues. They discuss the protocol versions, minimising slot growth, minimising lag, and some tips and tricks for scaling things well.
Here are some links to things they mentioned:
* PeerDB www.peerdb.io/
* Our episode on logical replication postgres.fm/episodes/logical-...
* Exploring versions of the Postgres logical replication protocol (blog post by Sai) blog.peerdb.io/exploring-vers...
* Logical Streaming Replication Protocol www.postgresql.org/docs/curre...
* REPLICA IDENTITY FULL www.postgresql.org/docs/curre...
* On the performance impact of REPLICA IDENTITY FULL in Postgres (blog post by Xata) xata.io/blog/replica-identity...
* max_slot_wal_keep_size www.postgresql.org/docs/curre...
* Active Active in Postgres 16 (blog post by Crunchy Data) www.crunchydata.com/blog/acti...
* pgEdge www.pgedge.com/
* DistSQL (term used by Mark Callaghan) smalldatum.blogspot.com/2023/...
* Five tips on Postgres logical decoding (blog post by Sai) blog.peerdb.io/five-tips-on-p...
* PG Slot Notify: Monitor Postgres Slot Growth in Slack (blog post by PeerDB) blog.peerdb.io/pg-slot-notify...
~~~
What did you like or not like? What should we discuss next time? Let us know in the comments, or by tweeting us on @postgresfm / postgresfm , @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 video version. Check out postgres.fm to subscribe to the audio-only version, to see the transcript, guest profiles, and more.