Episode 212 Slow Queries, 4TB Upgrade, Postgres on ZFS, Storage Stampede

<p>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.</p> <p>Subscribe at https://www.scalingpostgres.com to get notified of new episodes.</p> <p>Links for this episode:</p> <ul> <li><a href= "https://pgdash.io/blog/slow-queries-postgres.html">https://pgdash.io/blog/slow-queries-postgres.html</a></li> <li><a href= "https://retool.com/blog/how-we-upgraded-postgresql-database/">https://retool.com/blog/how-we-upgraded-postgresql-database/</a></li> <li><a href= "https://lackofimagination.org/2022/04/our-experience-with-postgresql-on-zfs/"> https://lackofimagination.org/2022/04/our-experience-with-postgresql-on-zfs/</a></li> <li><a href= "https://www.enterprisedb.com/blog/steady-storage-stampede">https://www.enterprisedb.com/blog/steady-storage-stampede</a></li> <li><a href= "https://tech.instacart.com/the-vanishing-thread-and-postgresql-tcp-connection-parameters-93afc0e1208c"> https://tech.instacart.com/the-vanishing-thread-and-postgresql-tcp-connection-parameters-93afc0e1208c</a></li> <li><a href= "https://www.cybertec-postgresql.com/en/find-and-fix-a-missing-postgresql-index/"> https://www.cybertec-postgresql.com/en/find-and-fix-a-missing-postgresql-index/</a></li> <li><a href= "https://www.percona.com/blog/postgresql-14-b-tree-index-reduced-bloat-with-bottom-up-deletion/"> https://www.percona.com/blog/postgresql-14-b-tree-index-reduced-bloat-with-bottom-up-deletion/</a></li> <li><a href= "https://pganalyze.com/blog/5mins-postgres-hot-updates-vs-bottom-up-index-deletion"> https://pganalyze.com/blog/5mins-postgres-hot-updates-vs-bottom-up-index-deletion</a></li> <li><a href= "https://www.youtube.com/watch?v=oJj-pltxBUM">https://www.youtube.com/watch?v=oJj-pltxBUM</a></li> <li><a href= "https://www.postgresql.fastware.com/blog/two-phase-commits-for-logical-replication-publications-subscriptions"> https://www.postgresql.fastware.com/blog/two-phase-commits-for-logical-replication-publications-subscriptions</a></li