Opened 12 months ago

Last modified 6 months ago

#5083 new enhancement

Reduce gist INDEX updates during topology buildig/editing

Reported by: strk Owned by: strk
Priority: medium Milestone: PostGIS 3.4.0
Component: topology Version:
Keywords: performance Cc:


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)

Change History (2)

comment:1 by strk, 12 months ago

Keywords: performance added

comment:2 by robe, 6 months ago

Milestone: PostGIS 3.3.0PostGIS 3.4.0
Note: See TracTickets for help on using tickets.