Opened 8 years ago
Last modified 8 years ago
#3611 closed defect
Geography distance performance regression — at Initial Version
Reported by: | dbaston | Owned by: | pramsey |
---|---|---|---|
Priority: | blocker | Milestone: | PostGIS 2.3.0 |
Component: | postgis | Version: | master |
Keywords: | Cc: |
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)
.
Note:
See TracTickets
for help on using tickets.