[postgis-tickets] [PostGIS] #3611: Geography distance performance regression

[PostGIS]

#3611: Geography distance performance regression
---------------------+---------------------------
 Reporter:  dbaston  |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  medium   |  Milestone:  PostGIS 2.3.0
Component:  postgis  |    Version:  trunk
 Keywords:           |
---------------------+---------------------------
 The following query takes 240ms on a fresh install of 2.2, and 2900ms on a
 fresh install from trunk.

 {{{
 SELECT setseed(0.1);
 WITH pts AS
     (SELECT ST_MakePoint(-180 + 360*random(), -90 +
 180*random())::geography AS geog FROM generate_series(1, 200))
 SELECT max(ST_Distance(a.geog, b.geog)) FROM pts a, pts b;
 }}}

 Results are similar if the call is {{{ST_Distance(a.geom, b.geog,
 false)}}}.

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