Re: Do we want a hashset type?

Поиск
Список
Период
Сортировка
От Tom Dunstan
Тема Re: Do we want a hashset type?
Дата
Msg-id CAPPfruxMELrBtq9XCJ6VNd9W7rLbJ1E3CV8yP+k-EZkbgBPhyg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Do we want a hashset type?  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
Ответы Re: Do we want a hashset type?  ("Joel Jacobson" <joel@compiler.org>)
Re: Do we want a hashset type?  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
Список pgsql-hackers
On Mon, 12 Jun 2023 at 22:37, Tomas Vondra <tomas.vondra@enterprisedb.com> wrote:
Perhaps. So you're proposing to have this as a regular built-in type?
It's hard for me to judge how popular this feature would be, but I guess
people often use arrays while they actually want set semantics ...

Perspective from a potential user: I'm currently working on something where an array-like structure with fast membership test performance would be very useful. The main type of query is doing an =ANY(the set) filter, where the set could contain anywhere from very few to thousands of entries (ints in our case). 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.

Our app runs connecting to either an embedded postgres database that we control or an external one controlled by customers - this is typically RDS or some other cloud vendor's DB. Having such a type as a separate extension would make it unusable for us until all relevant cloud vendors decided that it was popular enough to include - something that may never happen, or even if it did, now any time soon.

Cheers

Tom

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

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: [DOC] Update ALTER SUBSCRIPTION documentation v3
Следующее
От: Masahiko Sawada
Дата:
Сообщение: Re: Fix a typo in md.c