Scaling Postgres

In this episode of Scaling Postgres, we discuss Postgres 13 Beta 2, a system stats extension, tuning your operating systems for Postgres and different join strategies. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.postgresql.org/about/news/2047/ https://www.youtube.com/watch?v=G5f2dfIB4GY https://pgsnake.blogspot.com/2020/06/systemstats-extension-for-postgresql.html https://hunleyd.github.io/posts/tuned-PG-and-you/ https://www.cybertec-postgresql.com/en/join-strategies-and-performance-in-postgresql/ http://www.sai.msu.su/~megera/postgres/talks/json-unification-database-meetup-2020.pdf https://www.cybertec-postgresql.com/en/postgresql-ltree-vs-with-recursive/ https://pganalyze.com/blog/active-record-subqueries-rails https://info.crunchydata.com/blog/composite-primary-keys-postgresql-and-django https://www.highgo.ca/2020/06/22/types-of-indexes-in-postgresql/ https://www.2ndquadrant.com/en/blog/oracle-to-postgresql-reasons-to-migrate/ htt