[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  |  
-------------------------+--------------------------------------------------
Changes (by strk):

 * cc: bjornharrtell (added)


Comment:

 As indexes make database size bigger and slow down insertions/updates (see
 https://github.com/postgis/postgis/pull/30#issuecomment-68251146) an
 alternative would be to seek for the edge to be updated within the set of
 edges that should have been already fetched to check for intersection, or
 use the endpoint nodes indexes. That is, rewriting the update sql query.

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