|
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/ |