[postgis-tickets] [PostGIS] #2083: ST_RemEdgeModFace performance review

[PostGIS]

#2083: ST_RemEdgeModFace performance review
--------------------------+-----------------------------
  Reporter:  strk         |      Owner:  strk
      Type:  enhancement  |     Status:  new
  Priority:  medium       |  Milestone:  PostGIS Fund Me
 Component:  topology     |    Version:  2.0.x
Resolution:               |   Keywords:  performance
--------------------------+-----------------------------

Comment (by strk):

 In a case I'm looking at I confirm that adding an index on
 abs(relation.elem_id) improves the speed. In my case from 64 seconds to 13
 seconds to remove 7207 unused edges.

 Related ticket: #4887

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