Re: Plan stability versus near-exact ties in cost estimates

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Plan stability versus near-exact ties in cost estimates
Дата
Msg-id 8196.1334936942@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Plan stability versus near-exact ties in cost estimates  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
Список pgsql-hackers
"Albe Laurenz" <laurenz.albe@wien.gv.at> writes:
> Tom Lane wrote:
>> Um, that is what the proposed patch does.

> I was referring to the first two lines that the patch removes.
> I guess I don't understand why they should go.

What we'd have left after the proposed removal is
                           if (new_path->rows < old_path->rows)                                 remove_old = true;  /*
newdominates old */                           else                                 accept_new = false; /* old equals or
dominatesnew */
 

There's no need to make more than one test on the rows values.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Foreign table scan estimates
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Plan stability versus near-exact ties in cost estimates