Re:Working around a case where the Postgres planner is “not ...
by valyagolev on Monday August 02, 2021 @04:20PM
(#28042092)
query planner is a very complex, unpredictable piece of software that makes decisions I end up paying for. yes, I want it dismantled, and the same problem addressed somehow otherwise. maybe via dumber "query planners" and better "hints", even though the word "hint" doesn't go far enough in the direction of control that I need. I won't be sorry about this opinion even if you're used to this state of affairs
(i edited my comment very slightly to avoid getting more responses like yours)
There's so many queries NOT blogged about that just do the thing you want pretty much all the time, for no extra work on your part.