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

PostGIS trac at osgeo.org
Sun Aug 11 17:38:14 PDT 2013


#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:           |  
---------------------+------------------------------------------------------
 I presume geography  in 2.0.4 and goegraphy in 2.1 should return the same
 answer.  In benchmarking client's dat I found something slighly troubling:


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

 }}}

 when I run this on


 {{{
 POSTGIS="2.0.4SVN r11708" GEOS="3.4.0dev-CAPI-1.8.0 r0" PROJ="Rel. 4.8.0,
 6 March 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: 157.613 ms
 }}}

 On

 {{{
  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
 -------
    395
 (1 row)


 Time: 218.903 ms
 }}}


 whammo I got 2 geometries less and lost a good chunk of speed.

 I ran a couple of times on each database with similar timings.


 I'll try to get permission from client to release this datasource, but in
 mean time I'll try to narrow down to the offending geometries.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2422>
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.


More information about the postgis-tickets mailing list