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

[PostGIS]

#2083: ST_RemEdgeModFace performance review
-------------------------+--------------------------------------------------
 Reporter:  strk         |       Owner:  strk         
     Type:  enhancement  |      Status:  new          
 Priority:  medium       |   Milestone:  PostGIS 2.1.0
Component:  topology     |     Version:  2.0.x        
 Keywords:               |  
-------------------------+--------------------------------------------------
 ST_RemEdgeModFace queries the relation table to see if a face can be
 destroyed without affecting existing TopoGeometry objects.
 The query does not find any usable index because the only index we have is
 on all the columns and that query isn't using a match on all the column.

 We could do two things:
  1. See if it's possible to rewrite the query to make use of the index
  2. Add an additional index on the table

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