[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
Resolution:           |   Keywords:
----------------------+---------------------------
Description changed by dbaston:

Old description:

> 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)}}}.

New description:

 The following query takes 240ms on a fresh install of the 2.2 branch, 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#comment:1>
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.