Changes between Initial Version and Version 1 of Ticket #3131, comment 12
- Timestamp:
- 05/30/15 23:32:55 (10 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #3131, comment 12
initial v1 6 6 {{{ 7 7 set enable_seqscan = true; --with index use fails (when use_spheroid = true ) 8 SELECT a.gid, ST_geometryType(a.geog::geometry), ARRAY(SELECT (gid,a.geog <-> g.geog) 9 FROM knn_recheck_geog As g WHERE a.gid <> g.gid ORDER BY a.geog <-> g.geog LIMIT 5) , 10 ARRAY(SELECT (gid ) 11 FROM knn_recheck_geog As g WHERE a.gid <> g.gid ORDER BY ST_Distance(a.geog, g.geog) LIMIT 5) 12 FROM knn_recheck_geog As a 13 WHERE a.gid IN(500000,500001,1000,2614) 14 ORDER BY a.gid; 8 SELECT gid --, RANK() OVER(ORDER BY ST_Distance( 'POINT(95 10)'::geography, geog) ) 9 FROM knn_recheck_geog 10 ORDER BY 'POINT(95 10)'::geography <-> geog LIMIT 5; 15 11 16 12 }}} 17 13 14 I can't get the small ones to use an index anymore -- and if I unremark out the rank in above, also refuses to use an index. 15 18 16 19 17 I'm okay with sacrificing and just putting in a note in docs tht <-> uses sphere instead of spheroid. Unless you think there is an easy fix or its just uncovering a more serious issue.