[postgis-users] R-TREE

[Stephen Woodbridge]

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.

You might want to post your SQL and see if anyone can suggest how to 
speed it up. You should also post the explain plan for the SQL.

-Steve W.