StormaticsStormatics

Cutting a Production PostgreSQL Database’s WAL Generation by ~25%: A Diagnostic Story

How a systematic, evidence-first approach to database performance tuning uncovered, and helped fix, a compounding set of issues on a fast-growing social analytics platform’s PostgreSQL instance. Key Takeaways Diagnosed a production PostgreSQL instance generating approximately 1.8 TB of WAL per day Checkpoint tuning (shifting from a timer-based to a volume-based trigger) was the single biggest […]
Read More