Show Plans, WAL Monitoring, Using UUIDs, Default Logging | Scaling Postgres 109
In this episode of Scaling Postgres, we discuss how to show live plans, how Postgres 13 allows WAL monitoring, how to use UUIDs in your app and how logging is setup by default.
Subscribe at https://www.scalingpostgres.com to get notified of new episodes.
Links for this episode:
https://www.cybertec-postgresql.com/en/detailed-look-on-the-new-postgresql-troubleshooting-extension-pg_show_plans/
https://rjuju.github.io/postgresql/2020/04/07/new-in-pg13-WAL-monitoring.html
https://rjuju.github.io/postgresql/2020/04/04/new-in-pg13-monitoring-query-planner.html
https://medium.com/better-programming/empowering-a-rails-application-with-uuid-as-default-primary-key-44cd740828e8
https://mydbanotebook.org/post/debian-default-logging-explained/
https://www.highgo.ca/2020/04/10/stored-procedures-in-pg-11-better-late-then-never/
https://abdulyadi.wordpress.com/2020/04/07/parallel-query-inside-function/
https://info.crunchydata.com/blog/optimize-postgresql-server-performance
https://www.youtube.com/watch?v=9SGU6k8DkHU
https://postgresql.life/post/michael_paquier/
https://info.crunchydata.com/blog/polygon-averaging-in-postgis
https://www.2ndquadrant.com/en/blog/how-to-use-the-random-forest-machine-learning-model-with-2uda-postgresql-and-orange-part-3/
Create your
podcast in
minutes
It is Free