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

PostGIS trac at osgeo.org
Mon Nov 5 09:41:52 PST 2012

#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.

More information about the postgis-devel mailing list