Re: Do we want a hashset type?

Поиск
Список
Период
Сортировка
От Tom Dunstan
Тема Re: Do we want a hashset type?
Дата
Msg-id CAPPfruySQDMaV41Tj8yBFGF6L0cd2Brr8L1eZPbosR=HKX5ysw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Do we want a hashset type?  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
Список pgsql-hackers
On Wed, 14 Jun 2023 at 19:14, Tomas Vondra <tomas.vondra@enterprisedb.com> wrote:
> ...So we'd want the same index usage as
> =ANY(array) but would like faster row checking than we get with an array
> when other indexes are used.

We kinda already do this since PG14 (commit 50e17ad281), actually. If
the list is long enough (9 values or more), we'll build a hash table
during query execution. So pretty much exactly what you're asking for.

Ha! That is great. Unfortunately we can't rely on it as we have customers using versions back to 12. But good to know that it's available when we bump the required versions.

Thanks

Tom

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

Предыдущее
От: Thomas Munro
Дата:
Сообщение: Re: Inconsistent results with libc sorting on Windows
Следующее
От: "Tristan Partin"
Дата:
Сообщение: Re: [PATCH] Missing dep on Catalog.pm in meson rules