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

From: Mike Christensen <mike(at)kitchenpc(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: What's the best type of index for an ENUM column?
Date: 2010-06-08 03:12:07
Message-ID: AANLkTikvLCQcev0WS_1VvCYIg5INi7JHlU89X5PAtOGY@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-06-08 03:31:59 Re: What's the best type of index for an ENUM column?
Previous Message Mike Christensen 2010-06-08 03:03:58 Re: Does npgsql have a bunch of bugs with DB enums?