Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group