Scaling Postgres

In this episode of Scaling Postgres, we discuss the release of Postgres 13 RC1, how to upgrade Postgres at scale, using limit with ties and understanding Heap Only Tuple (HOT) updates. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.postgresql.org/about/news/2072/ https://about.gitlab.com/blog/2020/09/11/gitlab-pg-upgrade/ https://www.2ndquadrant.com/en/blog/postgresql-13-limit-with-ties/ https://www.cybertec-postgresql.com/en/hot-updates-in-postgresql-for-better-performance/ https://www.2ndquadrant.com/en/blog/7-best-practice-tips-for-postgresql-bulk-data-loading/ https://info.crunchydata.com/blog/postgresql-13-hidden-gems https://info.crunchydata.com/blog/exploring-plpy-turn-postgres-table-data-into-a-numpy-array https://momjian.us/main/writings/pgsql/AI.pdf https://www.citusdata.com/blog/2020/09/17/citus-and-postgres-at-any-scale/ https://postgresql.life/post/anthony_nowocien/