[postgis-users] R-TREE

strk at refractions.net strk at refractions.net
Tue Jun 28 04:14:43 PDT 2005


On Tue, Jun 28, 2005 at 12:00:38PM +0100, Luksana Sridawong wrote:
> hello all,
>  
> Can I create index by using rtree?
> now I create index by using gist and run vacuum analyze but map stil slow ,Well I thing if I create index by using rtree maybe it make my map fast more.I am not sure PostGIS support rtree or not?
>  
> thank you forword.

Index used by postgis IS an rtree implemented using GiST.
Check 'explain analyze' output to see whether the index
is used or not.

--strk;



More information about the postgis-users mailing list