
Scaling Postgres Episode 207 Autovacuum Configuration, Duplicate Key Violations, Pipelining, Tuning max_wal_size
Get New Episodes Weekly!
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