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/