Opened 9 months ago

Last modified 2 months ago

#5681 new enhancement

Document transaction management for topology

Reported by: strk Owned by: strk
Priority: medium Milestone: PostGIS 3.6.0
Component: documentation Version: master
Keywords: documentation, topology, management Cc:

Description

Experiences like the one written in https://gitlab.com/nibioopensource/resolve-overlap-and-gap/-/issues/67 show a value in documenting how using shorter-lived transaction can greatly improve performance by reducing the size of indices.

Documenting in the PostGIS manual would be useful. We do have a section about managing statistics, but that section does not mention managing vacuums, see:

https://www.postgis.net/docs/manual-dev/Topology.html#Topology_StatsManagement

Change History (2)

comment:1 by strk, 9 months ago

Component: topologydocumentation
Keywords: topology management added
Owner: changed from strk to robe

comment:2 by robe, 2 months ago

Milestone: PostGIS 3.5.0PostGIS 3.6.0
Owner: changed from robe to strk
Note: See TracTickets for help on using tickets.