Re: Index usage btree+gist ?

From: Arnaud Lesauvage <thewild(at)freesurf(dot)fr>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Index usage btree+gist ?
Date: 2006-02-17 15:24:02
Message-ID: 43F5EA92.70608@freesurf.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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 !

Regards
--
Arnaud

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Sears, Jeremy 2006-02-17 15:55:10 php cant see new table!!
Previous Message Tom Lane 2006-02-17 15:21:37 Re: Index usage btree+gist ?