Search

Home > Scaling Postgres > Episode 238 Slow Updates, Lateral Joins, Serial To Identity, PG 15 Changes


	Podcast:		Scaling Postgres
	Episode:		Episode 238 Slow Updates, Lateral Joins, Serial To Identity, PG 15 Changes
	Category:		Technology
	Duration:		00:13:06
	Publish Date:		2022-10-24 01:24:00
	Description:		In this episode of Scaling Postgres, we discuss why and what to do when updates are slow, use cases for lateral joins, moving from serial to identity for auto-incrementing ids and changes to Postgres 15. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.cybertec-postgresql.com/en/why-are-my-postgresql-updates-getting-slower/ https://pganalyze.com/blog/5mins-postgres-debug-UPDATE-bloated-tables-auto-explain-pageinspect https://sqlfordevs.com/for-each-loop-lateral-join https://adamj.eu/tech/2022/10/21/migrate-postgresql-ids-serial-identity-django-4.1/ https://blog.rustprooflabs.com/2022/10/postgres-15-config-changes https://pgconfig.rustprooflabs.com/param/change/14/15 https://www.enterprisedb.com/blog/exclusive-backup-mode-finally-removed-postgres-15 https://fluca1978.github.io/2022/10/21/PostgreSQL15JsonLogs.html https://www.enterprisedb.com/blog/postgres-15-adds-copy-header-and-matching https://www.endpointdev.com/blog/2022/10/upgrading-postgresql-14-to-15-on-fedora-centos-rocky-alma-linux/ https://www.bostongis.com/blog/index.php?/archives/278-Using-pg_upgrade-to-upgrade-PostgreSQL-9.6-PostGIS-2.4-to-PostgreSQL-15-3.3-on-Yum.html https://www.softwareandbooz.com/postgresql-at-the-pass-data-community-summit-2022/ https://postgres.fm/episodes/stored-procedures https://postgresql.life/post/cedric_duprez/ https://www.rubberduckdevshow.com/episodes/62-staying-off-the-rails-with-joel-drapper/
	Total Play:		0