[postgis-tickets] [PostGIS] #3321: Performance regression in topology load

[PostGIS]

#3321: Performance regression in topology load
-----------------------+---------------------------
  Reporter:  strk      |      Owner:  strk
      Type:  defect    |     Status:  new
  Priority:  medium    |  Milestone:  PostGIS 2.2.1
 Component:  topology  |    Version:  trunk
Resolution:            |   Keywords:
-----------------------+---------------------------

Comment (by strk):

 The time difference becomes worst when the topology is pre-populated.
 Here's the case after the first 20k polygons loaded:
 {{{
 -- limit 10k offset 20k  real    8m17.509s [2.2.0dev] addLinestring
 -- limit 10k offset 20k  real    1m53.791s [2.1.9dev] addLinestring
 }}}

 The 2.1.9 version loads 10k polygons in about half the time it loaded 20k
 before.
 The 2.2.0 version loads 10k polygons in more time than it loaded 20k
 before.

 It might have to do with index misuse.

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