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

Mike Christensen <mike@kitchenpc.com> writes:
> 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!

You aren't going to find that anything else beats out btree, I expect.
If we had bitmap indexes, those might be superior; but we don't.

            regards, tom lane