Re: [GENERAL] Perfomance of IN-clause with many elements and possiblesolutions

Поиск
Список
Период
Сортировка
От Dmitry Lazurkin
Тема Re: [GENERAL] Perfomance of IN-clause with many elements and possiblesolutions
Дата
Msg-id b31525c2-b22a-a810-3a12-b3667515753a@gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Perfomance of IN-clause with many elements and possible solutions  (Jeff Janes <jeff.janes@gmail.com>)
Ответы Re: [GENERAL] Perfomance of IN-clause with many elements and possible solutions  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-general
Дерево обсуждения
On 31.07.2017 19:42, Jeff Janes wrote:
I think it is simply because no one has gotten around to implementing it that way.  When you can just write it as a values list instead, the incentive to make the regular in-list work better is not all that strong.

Cheers,

Jeff

I see from explain that IN-clause uses just array with function ANY. I think for efficient implementation of this task I should implement new datatype "hashset". Am I wrong?

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

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: [GENERAL] Perfomance of IN-clause with many elements and possible solutions
Следующее
От: "Peter J. Holzer"
Дата:
Сообщение: Re: [GENERAL] Dealing with ordered hierarchies