Hi, On 2023-03-06 17:02:38 +0530, Amit Kapila wrote: > Andres, do you have any thoughts on this? We seem to have figured out > the cause of regression in the case Shi-San has reported and others > also agree with it. We can't think of doing anything better than what > the patch currently is doing, so thought of going with an option to > allow users to disable index scans. The current understanding is that > the patch will be a win in much more cases than the cases where one > can see regression but still having a knob could be useful in those > few cases.
I think the case in which the patch regresses performance in is irrelevant in practice. It's good to not regress unnecessarily for easily avoidable reason, even in such cases, but it's not worth holding anything up due to it. Greetings, Andres Freund
