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/