4 ms·
happened to us but for an even weirder case. postgres wasn’t doing a simple index-only scan because, as i learned from googling, the row of the table wasn’t tha
by valyagolev 5y ago
happened to us but for an even weirder case. postgres wasn’t doing a simple index-only scan because, as i learned from googling, the row of the table wasn’t that much wider than the index. creating a huge extra column helped
i wish there was no fancy query planner at all, and definitely no obligatory ones. it’s 2021, we either learn how to plan computation, or can afford not to care
- hobs 5y agoThere's so many cases where this is the wrong opinion that it is mind boggling to see. 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.
- valyagolev 5y agoquery 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)