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

From Arnaud Lesauvage
Subject Re: Index usage btree+gist ?
Date
Msg-id 43F5EA92.70608@freesurf.fr
Whole thread Raw
In response to Re: Index usage btree+gist ?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Tom Lane a écrit :
> Arnaud Lesauvage <thewild@freesurf.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 !

Regards
--
Arnaud


pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Index usage btree+gist ?
Next
From: "Shaler"
Date:
Subject: reinstallation of Posstgresql 8.0 program