Mike Christensen <mike@xxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
