[postgis-tickets] [PostGIS] #4952: Speed up ring building in ValidateTopology

[PostGIS]

#4952: Speed up ring building in ValidateTopology
--------------------------+---------------------------
  Reporter:  strk         |      Owner:  strk
      Type:  enhancement  |     Status:  closed
  Priority:  medium       |  Milestone:  PostGIS 3.2.0
 Component:  topology     |    Version:
Resolution:  fixed        |   Keywords:
--------------------------+---------------------------
Changes (by Sandro Santilli <strk@…>):

 * status:  new => closed
 * resolution:   => fixed


Comment:

 In [changeset:"406ecaab3296aa7630e9a887b0d736979f077c49/git" 406ecaa/git]:
 {{{
 #!CommitTicketReference repository="git"
 revision="406ecaab3296aa7630e9a887b0d736979f077c49"
 ValidateTopology: build all rings in a single statement

 Closes #4952

 Implements GetRingEdges internally, to avoid the subtransaction
 while still surviving non-closed rings.

 In real world case it reduces the cost of building 20356 rings
 from ~100 seconds to ~20 seconds
 }}}

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4952#comment:3>
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.