Data
DraftPostgreSQL Performance Beyond Adding Indexes
A first-principles walkthrough of how I approach a slow PostgreSQL workload — before reaching for more hardware.
Draft — full write-up coming soon.
This piece will walk through the diagnostic order I use when a PostgreSQL workload is running slower than it should: reading query plans before dashboards, distinguishing a query problem from a schema problem, and where caching and read replicas actually fit versus where they're a bandage. Related: Scaling PostgreSQL for High-Read Workloads.