[postgis-tickets] [PostGIS] #2422: geography regression difference

[PostGIS]

#2422: geography regression difference
---------------------+------------------------------------------------------
 Reporter:  robe     |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  high     |   Milestone:  PostGIS 2.1.0
Component:  postgis  |     Version:  2.1.x        
 Keywords:           |  
---------------------+------------------------------------------------------

Comment(by robe):

 Running this test

 {{{

 SELECT COUNT(*) FROM face
 WHERE _ST_DWithinUnCached(geog, st_setsrid(st_makepoint(-71.0636,
 42.3584), 4326)::geography, 1609.344 );
 }}}

 {{{
  POSTGIS="2.1.0rc2 r11726" GEOS="3.4.0dev-CAPI-1.8.0 r0" PROJ="Rel. 4.8.0,
 6 Mar
 ch 2012" GDAL="GDAL 1.10.0, released 2013/04/24" LIBXML="2.7.8"
 LIBJSON="UNKNOWN
 " RASTER PostgreSQL 9.2.4, compiled by Visual C++ build 1600, 64-bit

  count
 -------
    397
 (1 row)


 Time: 161.412 ms
 }}}
 Looks closer to what I'd expect.

 On the 2.0.4 no such functions exist so can't compare.

 No such thing as _ST_DWithinTree, so closest which takes painfully long to
 run is

 {{{
 SELECT COUNT(*) FROM  face
 WHERE _ST_DistanceTree(geog, st_setsrid(st_makepoint(-71.0636, 42.3584),
 4326)::geography) <=  1609.344;
 }}}


 I'm still waiting for that one to finish

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2422#comment:4>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.