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/