[postgis-tickets] [PostGIS] #4887: Add index on topo.relation(topogeo_id, layer_id) ?

[PostGIS]

#4887: Add index on topo.relation(topogeo_id, layer_id) ?
--------------------------+-----------------------------
  Reporter:  strk         |      Owner:  strk
      Type:  enhancement  |     Status:  new
  Priority:  medium       |  Milestone:  PostGIS Fund Me
 Component:  topology     |    Version:
Resolution:               |   Keywords:  performance
--------------------------+-----------------------------

Comment (by strk):

 Upon adding such index, we'd need a function to warn user when such index
 is missing (TopologySummary?) and a function to add the index if missing.
 When adding a missing index we should maybe consider eventual indices
 added by users, which may either conflict in name or be useless duplicate
 after adding our own.

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