Scaling Postgres

In this episode of Scaling Postgres, we discuss mistakes you can make when doing schema changes, how best to cancel statements, looking into pg_rman, and looking at a pedantry removal. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://postgres.ai/blog/20220525-common-db-schema-change-mistakes https://www.cybertec-postgresql.com/en/cancel-hanging-postgresql-query/ https://www.highgo.ca/2022/05/27/how-to-do-backup-and-restore-for-postgresql-using-pg_rman/ https://mydbanotebook.org/post/pedantry/ https://pganalyze.com/blog/5mins-postgres-15-speeding-up-sort-performance https://www.timescale.com/blog/opentelemetry-where-sql-is-better-than-the-original/ https://www.crunchydata.com/blog/exporter2perfdata-connecting-postgres-monitoring-tools https://postgresql.life/post/masahiko_sawada/ https://www.rubberduckdevshow.com/episodes/43-typed-or-untyped-ruby/