[postgis-users] spatial query don't use index!

[yishh.lee]

Thanks.
This table size is 1200000 rows.
I create index originally:
CREATE INDEX user_idx_gin
  ON mapfriends."user"
  USING gist
  ((geometry));

now I replace with:
CREATE INDEX user_idx_gin
  ON mapfriends."user"
  USING gist
  ((geometry::box));

And query can use spatial index now.

Who can explain this?
2009-06-18 



yishh.lee 



发件人： Guillaume Lelarge 
发送时间： 2009-06-18  15:40:32 
收件人： PostGIS Users Discussion 
抄送： 
主题： Re: [postgis-users] spatial query don't use index! 
 
Suhr, Ralf a écrit :
> Your cost begin at value 0.00. The index is in use.
>  
The startup cost never shows if the index is in use or no. This is a
sequential scan, and no index is in use.
What is the size of the user table?
-- 
Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090618/eb9074a0/attachment.html>