range test for hash index?

Поиск
Список
Период
Сортировка
От Paul A Jungwirth
Тема range test for hash index?
Дата
Msg-id CA+renyV=Us-5XfMC25bNp-uWSj39XgHHmGE9Rh2cQKMegSj52g@mail.gmail.com
обсуждение исходный текст
Ответы Re: range test for hash index?  (Amit Kapila <amit.kapila16@gmail.com>)
Список pgsql-hackers
Hello,

I noticed the tests for range types do this:

create table numrange_test2(nr numrange);
create index numrange_test2_hash_idx on numrange_test2 (nr);

Does that need a `using hash`? It seems like that's the intention. We
only use that table for equality comparisions. The script already
creates a table with a btree index further up. If I don't drop the
table I can see it's not a hash index:

regression=# \d numrange_test2
           Table "public.numrange_test2"
 Column |   Type   | Collation | Nullable | Default
--------+----------+-----------+----------+---------
 nr     | numrange |           |          |
Indexes:
    "numrange_test2_hash_idx" btree (nr)

Everything else passes if I change just that one line in the
{sql,expected} files.

Regards,
Paul



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

Предыдущее
От: James Coleman
Дата:
Сообщение: Re: [DOC] Document auto vacuum interruption
Следующее
От: Alexander Korotkov
Дата:
Сообщение: Re: Write visibility map during CLUSTER/VACUUM FULL