Re: Query plan for "id IS NULL" on PK

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Query plan for "id IS NULL" on PK
Дата
Msg-id CAKFQuwb3mMRL-bAsMSo3ks78_4cYCV5qptxHPs7mSoKPz1w5Pg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Query plan for "id IS NULL" on PK  (Rob Sargent <robjsargent@gmail.com>)
Ответы Re: Query plan for "id IS NULL" on PK  (Rob Sargent <robjsargent@gmail.com>)
Список pgsql-general
Дерево обсуждения
On Tue, Feb 14, 2023 at 3:25 PM Rob Sargent <robjsargent@gmail.com> wrote:

When will id be null in a primary key?


The OP seems to be aware of this...

"We cannot change the query being executed. Is there any way we can make the query planner ignore `OR (id IS NULL)` (as that will never be the case for the PK) and use both `id` clauses in the index condition?"

David J.

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

Предыдущее
От: Rob Sargent
Дата:
Сообщение: Re: Query plan for "id IS NULL" on PK
Следующее
От: Rob Sargent
Дата:
Сообщение: Re: Query plan for "id IS NULL" on PK