[postgis-tickets] [PostGIS] #5083: Reduce gist INDEX updates during topology buildig/editing

[PostGIS]

#5083: Reduce gist INDEX updates during topology buildig/editing
-------------------------+---------------------------
 Reporter:  strk         |      Owner:  strk
     Type:  enhancement  |     Status:  new
 Priority:  medium       |  Milestone:  PostGIS 3.3.0
Component:  topology     |    Version:
 Keywords:               |
-------------------------+---------------------------
 I've noticed gist INDEXEs on topology primitives are often containing
 duplicate records due to frequent updates of tuples during topology
 editing.

 This ticket is to reduce such duplications.

 An idea to do so is separating the geometry data from the attributes and
 only ever update the geometry data when it needs be (not when adding more
 edges to existing edge endpoints).

 In order to change the data layout all clients should always ever edit the
 "face", "edge" and "node" relations, rather than sometimes use the
 knowledge about "edge_data" (which could be completely then removed)

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