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?


_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users