Hacker News new | ask | show | jobs
by nozzlegear 1 day ago
> periodically checking slow DB queries and finding ways to speed them up.

How does this work in practice?

1 comments

At least for me, I have a couple dozen years of DB experience but robot, given performance metrics, can get really close to optimal on a tactical level (single query or pattern of queries) but can't yet do the full normalize/denormalize level of improvements without supervision. But really solid if you have one misbehaving query and give it explain analyze access on a read only account