Tom Lane a écrit :
> Arnaud Lesauvage <thewild(at)freesurf(dot)fr> writes:
>> I was advised the PostGis list to use a multicolumn index on both
>> the integer column and the geometry column.
> You could try that (put the geometry column first!). I'm not sure how
> effective additional columns in a gist index really are, but it's worth
> experimenting with.
OK, I'll try this first then !
Thanks Tom !
In response to
pgsql-novice by date
|Next:||From: Sears, Jeremy||Date: 2006-02-17 15:55:10|
|Subject: php cant see new table!!|
|Previous:||From: Tom Lane||Date: 2006-02-17 15:21:37|
|Subject: Re: Index usage btree+gist ? |