Mike Christensen <m...@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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
