[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 3.2.0
Component:  topology     |    Version:
 Keywords:               |
-------------------------+---------------------------
 Operations like getting elements of a TopoGeometry (for TopoGeom::geometry
 cast) or clearing a TopoGeometry would benefit from such index.

 It could be a set of partial indices (per layer) or a single index, not
 sure what would perform better. I'm not even sure we want this to be done
 by core, but it seems clear to me that such an index would speed up
 operations at the TopoGeometry level

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