[postgis-tickets] [PostGIS] #3611: Geography distance performance regression
PostGIS
trac at osgeo.org
Tue Aug 9 17:58:04 PDT 2016
#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.
More information about the postgis-tickets
mailing list