Re: Any disadvantages of using =ANY(ARRAY()) instead of IN?

Поиск
Список
Период
Сортировка
От Clemens Eisserer
Тема Re: Any disadvantages of using =ANY(ARRAY()) instead of IN?
Дата
Msg-id CAFvQSYTuWsJ7k4d6otj6nWpvRAEw27_7aa6SNyofT3Yz+p00Yg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Any disadvantages of using =ANY(ARRAY()) instead of IN?  (Clemens Eisserer <linuxhippy@gmail.com>)
Список pgsql-performance
Hi,

I would be really grateful for feedback regardding this issue. Tom?

Should Ifile a bug-report about the optimizer trying too hard to
collapse the subquery and therefor generating a bad plan?
Its my understanding that a IN shouldn't perform any worse than ANY on
an ARRAY, right?

Thank you in advance, Clemens

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