Re: Bad cost estimate with FALSE filter condition

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Bad cost estimate with FALSE filter condition
Дата
Msg-id 4345.1426530415@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Bad cost estimate with FALSE filter condition  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-performance
Josh Berkus <josh@agliodbs.com> writes:
> So ... should I assume my diagnosis is correct?  Haven't heard any other
> suggestions.

I don't see any reason to think this is worth worrying about, or worth
spending planner cycles on to produce a cosmetically nicer cost estimate.
One-time filters always apply at the top plan level so they're unlikely
to change any planner choices.  Moreover, for any case other than the
not-terribly-interesting constant FALSE case, we're better off assuming
that the filter condition will be true (and so there's nothing to adjust).

            regards, tom lane


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

Предыдущее
От: Tomas Vondra
Дата:
Сообщение: Re: Performance issues
Следующее
От: Vivekanand Joshi
Дата:
Сообщение: Re: Performance issues