Episode 109 Show Plans | WAL Monitoring | Using UUIDs | Default Logging
Episode 109 Show Plans | WAL Monitoring | Using UUIDs | Default Logging

Episode 109 Show Plans | WAL Monitoring | Using UUIDs | Default Logging

Bikking

12 min
Business & Finance
Play

Description

<p>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.</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.cybertec-postgresql.com/en/detailed-look-on-the-new-postgresql-troubleshooting-extension-pg_show_plans/"> https://www.cybertec-postgresql.com/en/detailed-look-on-the-new-postgresql-troubleshooting-extension-pg_show_plans/</a></p> <p><a href= "https://rjuju.github.io/postgresql/2020/04/07/new-in-pg13-WAL-monitoring.html"> https://rjuju.github.io/postgresql/2020/04/07/new-in-pg13-WAL-monitoring.html</a></p> <p><a href= "https://rjuju.github.io/postgresql/2020/04/04/new-in-pg13-monitoring-query-planner.html"> https://rjuju.github.io/postgresql/2020/04/04/new-in-pg13-monitoring-query-planner.html</a></p> <p><a href= "https://medium.com/better-programming/empowering-a-rails-application-with-uuid-as-default-primary-key-44cd740828e8"> https://medium.com/better-programming/empowering-a-rails-application-with-uuid-as-default-primary-key-44cd740828e8</a></p> <p><a href= "https://mydbanotebook.org/post/debian-default-logging-explained/">https://mydbanotebook.org/post/debian-default-logging-explained/</a></p> <p><a href= "https://www.highgo.ca/2020/04/10/stored-procedures-in-pg-11-better-late-then-never/"> https://www.highgo.ca/2020/04/10/stored-procedures-in-pg-11-better-late-then-never/</a></p> <p><a href= "https://abdulyadi.wordpress.com/2020/04/07/parallel-query-inside-function/"> https://abdulyadi.wordpress.com/2020/04/07/parallel-query-inside-function/</a></p> <p><a href= "https://info.crunchydata.com/blog/optimize-postgresql-server-performance"> https://info.crunchydata.com/blog/optimize-postgresql-server-performance</a></p> <p><a href= "https://www.youtube.com/watch?v=9SGU6k8DkHU">https://www.youtube.com/watch?v=9SGU6k8DkHU</a></p> <p><a href= "https://postgresql.life/post/michael_paquier/">https:/

Uploader

pip_flow

pip_flow

Episode 109 Show Plans | WAL Monitoring | Using UUIDs | Default Logging - Listen Free | WowFM