[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