In this episode of Scaling Postgres, we discuss dealing with slow queries, upgrading a 4TB database, running Postgres on ZFS and handling a storage stampede.

Subscribe at https://www.scalingpostgres.com to get notified of new episodes.

Links for this episode:

• https://pgdash.io/blog/slow-queries-postgres.html
• https://retool.com/blog/how-we-upgraded-postgresql-database/
• https://lackofimagination.org/2022/04/our-experience-with-postgresql-on-zfs/
• https://www.enterprisedb.com/blog/steady-storage-stampede
• https://tech.instacart.com/the-vanishing-thread-and-postgresql-tcp-connection-parameters-93afc0e1208c
• https://www.cybertec-postgresql.com/en/find-and-fix-a-missing-postgresql-index/
• https://www.percona.com/blog/postgresql-14-b-tree-index-reduced-bloat-with-bottom-up-deletion/
• https://pganalyze.com/blog/5mins-postgres-hot-updates-vs-bottom-up-index-deletion
• https://www.youtube.com/watch?v=oJj-pltxBUM
• https://www.postgresql.fastware.com/blog/two-phase-commits-for-logical-replication-publications-subscriptions
• https://bytebase.com/blog/database-migration-sqlite-to-postgresql
• https://momjian.us/main/writings/pgsql/microservices.pdf
• https://www.enterprisedb.com/blog/use-master-password-pgadmin-4
• https://postgresql.life/post/bharath_rupireddy/
• https://www.rubberduckdevshow.com/episodes/39-where-should-you-put-business-logic/