[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] R-TREE
From:       Stephen Woodbridge <woodbri () swoodbridge ! com>
Date:       2005-06-28 12:35:05
Message-ID: 42C143F9.9010607 () swoodbridge ! com
[Download RAW message or body]

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.

[prev in list] [next in list] [prev in thread] [next in thread]