[postgis-devel] [PostGIS] #2082: Add index on edge_data.{start, end}_node

[PostGIS]

#2082: Add index on edge_data.{start,end}_node
----------------------+-----------------------------------------------------
 Reporter:  strk      |       Owner:  strk         
     Type:  defect    |      Status:  new          
 Priority:  medium    |   Milestone:  PostGIS 2.1.0
Component:  topology  |     Version:  2.0.x        
 Keywords:            |  
----------------------+-----------------------------------------------------
 Since start_node and end_node are foreign keys to node.node_id, removing
 isolated nodes becomes a very expensive operation when those fields are
 not indexed as they require a sequencial scan on the whole edges table for
 each DELETE.

 I've been waiting more than 30 minutes before killing a DELETE query aimed
 at cleaning up a topology...

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2082>
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.