TLDR Web Dev · ARTICLES & TUTORIALS
FINDING PERFORMANCE PROBLEMS BY DIFFING TWO GO PROFILES
Summary from the TLDR Web Dev newsletter
The DoltHub team had a mysterious 3x performance regression while working on Doltgres (a version-controlled Postgres-compatible database) compatibility with SQLAlchemy. They used Go's pprof tool to diff performance profiles between branches, which revealed that a hard-coded parameter was unnecessarily calling an expensive method to generate system table names on every table lookup.