Safety Systems, Failover Slots, Transaction ID Complications, Repartitioning | Scaling Postgres 118
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.
Subscribe at https://www.scalingpostgres.com to get notified of new episodes.
Links for this episode:
https://momjian.us/main/blogs/pgblog/2020.html#June_8_2020
https://www.2ndquadrant.com/en/blog/failover-slots-postgresql/
https://www.2ndquadrant.com/en/blog/10-things-postgres-could-improve-part-1/
https://info.crunchydata.com/blog/control-runaway-postgres-queries-with-statement-timeout
https://blog.hagander.net/repartitioning-with-logical-replication-in-postgresql-13-246/
https://www.percona.com/blog/2020/06/09/multi-master-replication-solutions-for-postgresql/
https://www.cybertec-postgresql.com/en/composite-type-performance-issues-in-postgresql/
https://www.highgo.ca/2020/06/12/transactions-in-postgresql-and-their-mechanism/
http://blog.cleverelephant.ca/2020/04/developer-life.html
http://blog.cleverelephant.ca/2020/06/developer-life-2.html
https://info.crunchydata.com/blog/postgis-with-postgresql-operator
https://www.pgbouncer.org/2020/06/pgbouncer-1-14-0
https://www.2ndquadrant.com/en/blog/how-to-use-adaboost-machine-learning-model-with-2uda-postgresql-and-orange-part-6/
https://postgresql.life/post/oleksii_kliukin/
Create your
podcast in
minutes
It is Free