Re: Query plan for NOT IN

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Query plan for NOT IN
Дата
Msg-id 7197.1254753036@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Query plan for NOT IN  (Matthew Wakeling <matthew@flymine.org>)
Список pgsql-performance
Matthew Wakeling <matthew@flymine.org> writes:
> Yes, that does work, but only because id is NOT NULL. I thought Postgres
> 8.4 had had a load of these join types unified to make it less important
> how the query is written?

NOT IN is not easily optimizable because of its odd behavior in the
presence of nulls.  Use NOT EXISTS instead, or that left join hack.

            regards, tom lane

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

Предыдущее
От: Grzegorz Jaśkiewicz
Дата:
Сообщение: Re: Query plan for NOT IN
Следующее
От: Stefan Kaltenbrunner
Дата:
Сообщение: Re: Best suiting OS