[postgis-tickets] [PostGIS] #3000: Edge linking does not use index

[PostGIS]

#3000: Edge linking does not use index
-------------------------+--------------------------------------------------
 Reporter:  strk         |       Owner:  strk         
     Type:  enhancement  |      Status:  new          
 Priority:  medium       |   Milestone:  PostGIS 2.2.0
Component:  topology     |     Version:  trunk        
 Keywords:  performance  |  
-------------------------+--------------------------------------------------

Comment(by strk):

 This patch modifies the SQL query of ST_ModEdgeSplit and ST_ModEdgeHeal to
 add a filter on start_node and end_node to get the opportunity to use
 existing indexes. Speeds up my syntetic test from 0.4 seconds to 0.064
 seconds (splitting and re-healing an edge in a ~500k edges topo).

  http://strk.keybit.net/tmp/useIndexOnSplitAndHealModEdge.patch

 Björn, could you test it against your use case ? The patch will need to be
 finished to replicate the code in the "NewEdge?" versions of the
 functions.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/3000#comment:4>
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.