In this episode of Scaling Postgres, we discuss practical partitioning, understanding pg_repack, explaining buffers and enforcing multi-row constraints.

Subscribe at https://www.scalingpostgres.com to get notified of new episodes.

Links for this episode:

https://www.postgresql.org/about/news/postgresql-14-beta-2-released-2249/

https://www.postgresvision.com/

https://vyruss.org/blog/practical-partitioning-in-production-with-postgres-postgres-vision-2021.html

https://www.percona.com/blog/2021/06/24/understanding-pg_repack-what-can-go-wrong-and-how-to-avoid-it/

https://www.depesz.com/2021/06/20/explaining-the-unexplainable-part-6-buffers/

https://www.cybertec-postgresql.com/en/postgresql-constraints-over-multiple-rows/

https://www.cybertec-postgresql.com/en/from-md5-to-scram-sha-256-in-postgresql/

https://www.depesz.com/2021/06/23/a-tale-of-making-company-wide-standard-psqlrc/

https://fabianlindfors.se/blog/schema-migrations-in-postgres/

https://pganalyze.com/blog/geodjango-postgis

https://postgresql.life/post/federico_campoli/

https://www.rubberduckdevshow.com/episodes/1-its-all-about-the-tests/