TLDR Web Dev · ARTICLES & TUTORIALS

FINDING PERFORMANCE PROBLEMS BY DIFFING TWO GO PROFILES

dolthub.com6 min read

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.