Changes between Initial Version and Version 1 of Ticket #3131, comment 12


Ignore:
Timestamp:
May 30, 2015 11:32:55 PM (4 years ago)
Author:
robe
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #3131, comment 12

    initial v1  
    66{{{
    77set 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;
     8SELECT gid --, RANK() OVER(ORDER BY ST_Distance( 'POINT(95 10)'::geography, geog) )
     9FROM knn_recheck_geog
     10ORDER BY 'POINT(95 10)'::geography <-> geog LIMIT 5;
    1511
    1612}}}
    1713
     14I 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
    1816
    1917I'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.