News for hackers. Stuff that matters.

A comment on How Postgres chooses which index to use for a query. Parent comment

Re:How Postgres chooses which index to use for a query by cameronh90 on Thursday April 21, 2022 @09:21PM (#31117189)
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...

[ Parent | on HN ]
Re:How Postgres chooses which index to use for a query by hermanradtke on Friday April 22, 2022 @10:02AM (#31121641)
This 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.

[ Parent | on HN ]