Search

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


	Podcast:		Scaling Postgres
	Episode:		Episode 212 Slow Queries, 4TB Upgrade, Postgres on ZFS, Storage Stampede
	Category:		Technology
	Duration:		00:21:24
	Publish Date:		2022-04-24 21:40:25
	Description:		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/
	Total Play:		0