What's the best type of index for an ENUM column?

Поиск
Список
Период
Сортировка
От Mike Christensen
Тема What's the best type of index for an ENUM column?
Дата
Msg-id AANLkTikvLCQcev0WS_1VvCYIg5INi7JHlU89X5PAtOGY@mail.gmail.com
обсуждение исходный текст
Ответы Re: What's the best type of index for an ENUM column?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
I have a column in a table that's an ENUM type.  What's the best type
of index for this?  It seems if I use a btree index, that's more
optimized for doing greater than or less than comparisons which don't
apply to an enum.  I will only be doing equals comparisons on these
columns.  Thanks!

Mike

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

Предыдущее
От: Mike Christensen
Дата:
Сообщение: Re: Does npgsql have a bunch of bugs with DB enums?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: What's the best type of index for an ENUM column?