Nachricht
Your
cost begin at value 0.00. The index is in use.
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
