[PostGIS] #5681: Document transaction management for topology

[PostGIS]

#5681: Document transaction management for topology
---------------------------+---------------------------
 Reporter:  strk           |      Owner:  strk
     Type:  enhancement    |     Status:  new
 Priority:  medium         |  Milestone:  PostGIS 3.5.0
Component:  topology       |    Version:  master
 Keywords:  documentation  |
---------------------------+---------------------------
 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
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5681>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.