Opened 8 months ago

Last modified 8 months ago

#5681 new enhancement

Document transaction management for topology

Reported by: strk Owned by: robe
Priority: medium Milestone: PostGIS 3.5.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 (1)

comment:1 by strk, 8 months ago

Component: topologydocumentation
Keywords: topology management added
Owner: changed from strk to robe
Note: See TracTickets for help on using tickets.