Re: Query optimiser is not using 'not null' constraint when 'order by nulls last' clause is used

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Query optimiser is not using 'not null' constraint when 'order by nulls last' clause is used
Дата
Msg-id 15987.1517583616@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Query optimiser is not using 'not null' constraint when 'order bynulls last' clause is used  (Nandakumar M <m.nanda92@gmail.com>)
Ответы Re: Query optimiser is not using 'not null' constraint when 'order bynulls last' clause is used  (Nandakumar M <m.nanda92@gmail.com>)
Список pgsql-performance
Nandakumar M <m.nanda92@gmail.com> writes:
> The order by column has a not null constraint on it and so nulls last or
> first shouldn't make any difference.

The planner does not consider this and it doesn't really seem like
something worth expending cycles on.  If you know that there won't be
nulls in the column, why are you insisting on specifying a nondefault
value of NULLS FIRST/LAST in the query?

            regards, tom lane


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

Предыдущее
От: Nandakumar M
Дата:
Сообщение: Re: Query optimiser is not using 'not null' constraint when 'order bynulls last' clause is used
Следующее
От: Nandakumar M
Дата:
Сообщение: Re: Query optimiser is not using 'not null' constraint when 'order bynulls last' clause is used