3 ms·
> on real high-end workloads like DBMSs DBMSs are normally IO constrained or memory constrained, or lack-of-index index constrained or query-plan-gone-mental-f
by tempguy9999 7y ago
> on real high-end workloads like DBMSs
DBMSs are normally IO constrained or memory constrained, or lack-of-index index constrained or query-plan-gone-mental-from-cardinality-misestimation constrained, or others. It's very unusual IME to find one that is CPU constrained. Bringing up DBs in this context is peculiar to say the least.
I've literally just lost 20 hours trying to debug a query that intermittently ran many times too slow. It was a memory misconfiguration. Extra CPU is at best a bandage over these kinds of problems, at worst, just wasted.