Re: On disable_cost

Robert Haas <robertmhaas(at)gmail(dot)com> writes:
> On Tue, Mar 12, 2024 at 1:32 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> BTW, having written that paragraph, I wonder if we couldn't get
>> the same end result with a nearly one-line change that consists of
>> making disable_cost be IEEE infinity.

> I don't think so, because I think that what will happen in that case
> is that we'll pick a completely random plan if we can't pick a plan
> that avoids incurring disable_cost. Every plan that contains one
> disabled node anywhere in the plan tree will look like it has exactly
> the same cost as any other such plan.

Good point.

> IMHO, this is actually one of the problems with disable_cost as it
> works today.

Yeah. I keep thinking that the right solution is to not generate
disabled paths in the first place if there are any other ways to
produce the same relation. That has obvious order-of-operations
problems though, and I've not been able to make it work.

regards, tom lane