Episode 120 Postgres 13 Beta 2 | System Stats Extension | Tuned | Join Strategy

<p>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.</p> <p>Subscribe at https://www.scalingpostgres.com to get notified of new episodes.</p> <p>Links for this episode:</p> <p><a href= "https://www.postgresql.org/about/news/2047/">https://www.postgresql.org/about/news/2047/</a></p> <p><a href= "https://www.youtube.com/watch?v=G5f2dfIB4GY">https://www.youtube.com/watch?v=G5f2dfIB4GY</a></p> <p><a href= "https://pgsnake.blogspot.com/2020/06/systemstats-extension-for-postgresql.html"> https://pgsnake.blogspot.com/2020/06/systemstats-extension-for-postgresql.html</a></p> <p><a href= "https://hunleyd.github.io/posts/tuned-PG-and-you/">https://hunleyd.github.io/posts/tuned-PG-and-you/</a></p> <p><a href= "https://www.cybertec-postgresql.com/en/join-strategies-and-performance-in-postgresql/"> https://www.cybertec-postgresql.com/en/join-strategies-and-performance-in-postgresql/</a></p> <p><a href= "http://www.sai.msu.su/~megera/postgres/talks/json-unification-database-meetup-2020.pdf"> http://www.sai.msu.su/~megera/postgres/talks/json-unification-database-meetup-2020.pdf</a></p> <p><a href= "https://www.cybertec-postgresql.com/en/postgresql-ltree-vs-with-recursive/"> https://www.cybertec-postgresql.com/en/postgresql-ltree-vs-with-recursive/</a></p> <p><a href= "https://pganalyze.com/blog/active-record-subqueries-rails">https://pganalyze.com/blog/active-record-subqueries-rails</a></p> <p><a href= "https://info.crunchydata.com/blog/composite-primary-keys-postgresql-and-django"> https://info.crunchydata.com/blog/composite-primary-keys-postgresql-and-django</a></p> <p><a href= "https://www.highgo.ca/2020/06/22/types-of-indexes-in-postgresql/">https://www.highgo.ca/2020/06/22/types-of-indexes-in-postgresql/</a></p> <p><a href= "https://www.2ndquadrant.com/en/blog/oracle-to-postgresql-reasons-to-migrate/"> https://www.2ndquadrant.com/en/blog/oracle-to-postgresql-reasons-to-migrate/</a></p> <p><a href= "https://