Re: Index usage btree+gist ? - Mailing list pgsql-novice

Arnaud Lesauvage <thewild@freesurf.fr> writes:
> I have a table with a lot of rows (~3.000.000 I believe), and two
> indexes.
> The first one is a BTree index on a column (lets call it
> btreecolumn) which contains only 8 different integer values (from
> 0 to 8).

An index as unselective as that is almost useless.  It's not surprising
that the planner doesn't think it's worth the trouble to use it.

            regards, tom lane