[postgis-devel] Issue 95 in postgis: PostGIS 1.4 documentation update
codesite-noreply at google.com
codesite-noreply at google.com
Fri Mar 20 10:06:50 PDT 2009
Comment #14 on issue 95 by ke... at refractions.net: PostGIS 1.4 documentation
update
http://code.google.com/p/postgis/issues/detail?id=95
Granted. But if the planner never uses the index, then the caution note
still
stands, no? If the = operator is indexable, what am I doing wrong here
that it's not
engaging?
postgis=# set enable_seqscan = false;
SET
postgis=# EXPLAIN SELECT * FROM foo WHERE the_geom = 'POINT(0.5 0.5)';
QUERY PLAN
-------------------------------------------------------------------------------
Seq Scan on foo (cost=100000000.00..100001839.00 rows=100 width=84)
Filter: (the_geom
= '0101000000000000000000E03F000000000000E03F'::geometry)
(2 rows)
--
You received this message because you are listed in the owner
or CC fields of this issue, or because you starred this issue.
You may adjust your issue notification preferences at:
http://code.google.com/hosting/settings
More information about the postgis-devel
mailing list