Tom Lane a écrit :
> Arnaud Lesauvage <thewild(at)freesurf(dot)fr> writes:
>> I have a table with a lot of rows (~3.000.000 I believe), and two
>> 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.
OK, thanks for pointing this out.
I was advised the PostGis list to use a multicolumn index on both
the integer column and the geometry column.
Another suggestion was to cluster the table on the gist-geometry
What do you think about that ?
In response to
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2006-02-17 15:21:37|
|Subject: Re: Index usage btree+gist ? |
|Previous:||From: Finger Infratherapie||Date: 2006-02-17 15:05:59|
|Subject: readline library not found|