PostgreSQL Performance Tuning on a 10TB Database: What Actually Worked

Our PostgreSQL cluster crossed 10TB sometime in late 2024. I remember because that was also the week our reporting service started returning HTTP 504s intermittently, and the on-call rotation became a lot less fun. Seven engineers on the team, one da...