Re: Index usage btree+gist ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Arnaud Lesauvage <thewild(at)freesurf(dot)fr>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Index usage btree+gist ?
Date: 2006-02-17 14:58:29
Message-ID: 9284.1140188309@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Arnaud Lesauvage <thewild(at)freesurf(dot)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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Finger Infratherapie 2006-02-17 15:05:59 readline library not found
Previous Message Curt Schwaderer 2006-02-17 14:50:47 Writing Python triggers and the TD dictionary value