Scaling Postgres Episode 207 Autovacuum Configuration, Duplicate Key Violations, Pipelining, Tuning max_wal_size

In this episode of Scaling Postgres, we discuss how best to configure autovacuum, the dangers of duplicate key violations, how to set up pipelining, and how to tune max_wal_size.

Content Discussed

• Is my autovacuum configured properly?
• Hidden dangers of duplicate key violations in PostgreSQL and how to avoid them
• Pipeline mode for better PostgreSQL performance on slow networks
• Tuning max_wal_size in PostgreSQL
• PG Phriday: Wrapping Transactions Right Round
• Using pgTAP to automate database testing
• Hooks: The secret feature powering the Postgres ecosystem
• How to benchmark performance of Citus and Postgres with HammerDB on Azure
• 5mins of Postgres E9: PostGIS vs GPUs, tuning parallel queries, and automating Citus extension benchmarks with HammerDB
• Distributed Database With PostgreSQL – Atomic Commit Problems
• Run PostgreSQL on Kubernetes with Percona Operator & Pulumi
• Spatial Filters in pg_featureserv with CQL
• Jaime Casanova
• Rubber Duck Dev Show Episode 34 | Real World Performance Enhancements

YouTube Video