Understanding query planner quirks yielded a ~35% speedup.