Scaling Postgres

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