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

[Suhr, Ralf]

Your cost begin at value 0.00. The index is in use.
 
-----Ursprüngliche Nachricht-----
Von: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] Im Auftrag von lee yishh
Gesendet: Donnerstag, 18. Juni 2009 08:34
An: postgis-users at postgis.refractions.net
Betreff: [postgis-users] spatial query don't use index!



	Table mapfriends."user" has a geometry  field,and i create spatial index on it ,
	and do VACUUM ANALYZE,but when i use explain like that:
	explain SELECT * FROM mapfriends."user" where    geometry @  mapfriends.ST_BUFFER(mapfriends.geometryfromtext('POINT(119.58 31.99175)'),0.1);
	
	 
	It shows:
	
	Seq Scan on "user"  (cost=0.00..41682.57 rows=1053 width=244)
	
	The spatial index seems not be used.
	
	How should i do?
	
	

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090618/7fc234a0/attachment.html>