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 по дате отправления:

Предыдущее
От: "MauMau"
Дата:
Сообщение: Could synchronous streaming replication really degrade the performance of the primary?
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: Could synchronous streaming replication really degrade the performance of the primary?