Episode 118 Safety Systems | Failover Slots | Transaction ID Complications | Repartitioning
Episode 118 Safety Systems | Failover Slots | Transaction ID Complications | Repartitioning

Episode 118 Safety Systems | Failover Slots | Transaction ID Complications | Repartitioning

Bikking

15 min
Business & Finance
Play

Description

<p>In this episode of Scaling Postgres, we discuss safety systems, the purpose and existence of failover slots, complications with transaction IDs and how to repartition without downtime.</p> <p>Subscribe at https://www.scalingpostgres.com to get notified of new episodes.</p> <p>Links for this episode:</p> <p><a href= "https://momjian.us/main/blogs/pgblog/2020.html#June_8_2020">https://momjian.us/main/blogs/pgblog/2020.html#June_8_2020</a></p> <p><a href= "https://www.2ndquadrant.com/en/blog/failover-slots-postgresql/">https://www.2ndquadrant.com/en/blog/failover-slots-postgresql/</a></p> <p><a href= "https://www.2ndquadrant.com/en/blog/10-things-postgres-could-improve-part-1/"> https://www.2ndquadrant.com/en/blog/10-things-postgres-could-improve-part-1/</a></p> <p><a href= "https://info.crunchydata.com/blog/control-runaway-postgres-queries-with-statement-timeout"> https://info.crunchydata.com/blog/control-runaway-postgres-queries-with-statement-timeout</a></p> <p><a href= "https://blog.hagander.net/repartitioning-with-logical-replication-in-postgresql-13-246/"> https://blog.hagander.net/repartitioning-with-logical-replication-in-postgresql-13-246/</a></p> <p><a href= "https://www.percona.com/blog/2020/06/09/multi-master-replication-solutions-for-postgresql/"> https://www.percona.com/blog/2020/06/09/multi-master-replication-solutions-for-postgresql/</a></p> <p><a href= "https://www.cybertec-postgresql.com/en/composite-type-performance-issues-in-postgresql/"> https://www.cybertec-postgresql.com/en/composite-type-performance-issues-in-postgresql/</a></p> <p><a href= "https://www.highgo.ca/2020/06/12/transactions-in-postgresql-and-their-mechanism/"> https://www.highgo.ca/2020/06/12/transactions-in-postgresql-and-their-mechanism/</a></p> <p><a href= "http://blog.cleverelephant.ca/2020/04/developer-life.html">http://blog.cleverelephant.ca/2020/04/developer-life.html</a></p> <p><a href= "http://blog.cleverelephant.ca/2020/06/developer-life-2.html">http://blog.cleverelephant.ca/2020/06/developer-life-2.html</a></p> <p><

Uploader

pip_flow

pip_flow

Episode 118 Safety Systems | Failover Slots | Transaction ID Complications | Repartitioning - Listen Free | WowFM