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
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
