Opened 8 years ago

Last modified 8 years ago

#3611 closed defect

Geography distance performance regression — at Version 1

Reported by: dbaston Owned by: pramsey
Priority: blocker Milestone: PostGIS 2.3.0
Component: postgis Version: master
Keywords: Cc:

Description (last modified by dbaston)

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

Change History (1)

comment:1 by dbaston, 8 years ago

Description: modified (diff)
Note: See TracTickets for help on using tickets.