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

[PostGIS]

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

Comment (by laopsahl):

 Here is the list of all index I added when running resolve overlap
 (I will remove code when as upgrade to new Postgis versions)


 {{{
   EXECUTE Format('CREATE INDEX ON %s.relation(layer_id)',
 (_topology_info).topology_name);
   EXECUTE Format('CREATE INDEX ON %s.relation(abs(element_id))',
 (_topology_info).topology_name);
   EXECUTE Format('CREATE INDEX ON %s.relation(element_id)',
 (_topology_info).topology_name);
   EXECUTE Format('CREATE INDEX ON %s.relation(topogeo_id)',
 (_topology_info).topology_name);
   EXECUTE Format('CREATE INDEX ON %s.edge_data USING GIST (geom)',
 (_topology_info).topology_name);
   EXECUTE Format('CREATE INDEX ON %s.edge_data(abs_next_left_edge)',
 (_topology_info).topology_name);
   EXECUTE Format('CREATE INDEX ON %s.edge_data(abs_next_right_edge)',
 (_topology_info).topology_name);
   EXECUTE Format('CREATE INDEX ON %s.node(containing_face)',
 (_topology_info).topology_name);


 }}}

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