4 ms·
The biggest reason - which doesn't seem to be mentioned - is consistency and stability. I don't like being woken up to debug why the query planner has decided
by cameronh90 5y ago
The biggest reason - which doesn't seem to be mentioned - is consistency and stability.
I don't like being woken up to debug why the query planner has decided to do something new. Yes, there's always a "good reason" but does it need to communicate that by taking down production at 3am?
Even if it's a better plan, I don't need my anomaly detection alerts going off because something is now running in half the time...
- hermanradtke 5y agoThis is why I prefer to page on features working within SLA instead of lower level things like CPU usage or query time. Having a system send warnings about CPU or query time are great when I am awake. They are hints to a problem, but not always a problem themselves.