Episode 238 Slow Updates, Lateral Joins, Serial To Identity, PG 15 Changes

<p>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.</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://www.cybertec-postgresql.com/en/why-are-my-postgresql-updates-getting-slower/"> https://www.cybertec-postgresql.com/en/why-are-my-postgresql-updates-getting-slower/</a></li> <li><a href= "https://pganalyze.com/blog/5mins-postgres-debug-UPDATE-bloated-tables-auto-explain-pageinspect"> https://pganalyze.com/blog/5mins-postgres-debug-UPDATE-bloated-tables-auto-explain-pageinspect</a></li> <li><a href= "https://sqlfordevs.com/for-each-loop-lateral-join">https://sqlfordevs.com/for-each-loop-lateral-join</a></li> <li><a href= "https://adamj.eu/tech/2022/10/21/migrate-postgresql-ids-serial-identity-django-4.1/"> https://adamj.eu/tech/2022/10/21/migrate-postgresql-ids-serial-identity-django-4.1/</a></li> <li><a href= "https://blog.rustprooflabs.com/2022/10/postgres-15-config-changes"> https://blog.rustprooflabs.com/2022/10/postgres-15-config-changes</a></li> <li><a href= "https://pgconfig.rustprooflabs.com/param/change/14/15">https://pgconfig.rustprooflabs.com/param/change/14/15</a></li> <li><a href= "https://www.enterprisedb.com/blog/exclusive-backup-mode-finally-removed-postgres-15"> https://www.enterprisedb.com/blog/exclusive-backup-mode-finally-removed-postgres-15</a></li> <li><a href= "https://fluca1978.github.io/2022/10/21/PostgreSQL15JsonLogs.html">https://fluca1978.github.io/2022/10/21/PostgreSQL15JsonLogs.html</a></li> <li><a href= "https://www.enterprisedb.com/blog/postgres-15-adds-copy-header-and-matching"> https://www.enterprisedb.com/blog/postgres-15-adds-copy-header-and-matching</a></li> <li><a href= "https://www.endpointdev.com/blog/2022/10/upgrading-postgresql-14-to-15-on-fedora-centos-rocky-alma-linux/"> https://www.endpointdev.com/blog/2022/10/upgrading-pos