Scaling Postgres Episode 3 | Modeling | Query Performance | Statistics | pgmetrics

In this episode of Scaling Postgres, we review articles covering modeling, checking for long queries using pg_stat_statements, statistics in PosgreSQL 10 and pgmetrics.

Content Discussed

• Database Modelization Anti-Patterns
• Detecting Performance Problems Easily In PostgreSQL
• The Postgres 10 feature you didn't know about: CREATE STATISTICS
• Announcing pgmetrics
• Top PG Clustering HA Solutions for PostgreSQL
• PostgreSQL Meltdown Benchmarks
• PostgreSQL Backup & Point-In-Time Recovery

YouTube Video