[postgis-devel] [PostGIS] #1841: ST_Distance on PostGIS 2.0 is prohibitively slow

[PostGIS]

#1841: ST_Distance on PostGIS 2.0 is prohibitively slow
--------------------------------+-------------------------------------------
 Reporter:  andrewxhill         |       Owner:  pramsey      
     Type:  enhancement         |      Status:  new          
 Priority:  medium              |   Milestone:  PostGIS 2.1.0
Component:  postgis             |     Version:  2.0.x        
 Keywords:  st_distance, speed  |  
--------------------------------+-------------------------------------------

Comment(by strk):

 Syntetized dataset: http://strk.keybit.net/tmp/slowdist.zip
   avg/max/min points: 416.5136436597110754 | 582 |  10

 Takes over 6 minutes to run this:
 {{{
 select sum(d) from ( select a.a as g1, b.a as g2, st_distance(a.g, b.g) as
 d from a join a b on a.a<b.a ) as foo;
 }}}

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