Opened 2 years ago

Last modified 9 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 strk, 2 years ago

Keywords: performance added

comment:2 by robe, 20 months ago

Milestone: PostGIS 3.3.0PostGIS 3.4.0

comment:3 by strk, 9 months ago

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