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

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.

Content Discussed

Detailed look on the new PostgreSQL troubleshooting extension – pg_show_plans
New in pg13: WAL monitoring
New in pg13: Monitoring the query planner
Empowering a Rails Application With UUID as Default Primary Key
Debian Default Logging Explained
Stored Procedures in PG 11 – Better late then never
Parallel Query Inside Function
Optimize PostgreSQL Server Performance Through Configuration
[YouTube] Postgres Pulse Insights: How to Solve Bloated Postgres Database | Improve Database Performance
Michael Paquier
Polygon Averaging in PostGIS
How to use the Random Forest Machine Learning Model with 2UDA – PostgreSQL and Orange (Part 3)