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