Postgres 13 Beta 2, System Stats Extension, Tuned, Join Strategy | Scaling Postgres 120
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/
https://info.crunchydata.com/blog/setup-ora2pg-for-oracle-to-postgres-migration
https://postgresql.life/post/simon_riggs/
https://www.2ndquadrant.com/en/blog/how-to-monitor-postgresql-12-performance-with-omnidb-part-1/
https://www.highgo.ca/2020/06/25/authenticating-pgpool-ii-with-ldap/
https://www.2ndquadrant.com/en/blog/how-to-use-neural-network-machine-learning-model-with-2uda-postgresql-and-orange-part-7/
Create your
podcast in
minutes
It is Free