Opened 3 years ago
Last modified 16 months ago
#5083 new enhancement
Reduce gist INDEX updates during topology buildig/editing
Reported by: | strk | Owned by: | strk |
---|---|---|---|
Priority: | medium | Milestone: | PostGIS Fund Me |
Component: | topology | Version: | |
Keywords: | performance | Cc: |
Description
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 (3)
comment:1 by , 3 years ago
Keywords: | performance added |
---|
comment:2 by , 2 years ago
Milestone: | PostGIS 3.3.0 → PostGIS 3.4.0 |
---|
comment:3 by , 16 months ago
Milestone: | PostGIS 3.4.0 → PostGIS Fund Me |
---|