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/