[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:
-----------------------+---------------------------
Changes (by robe):

 * milestone:  PostGIS 2.2.0 => PostGIS 2.2.1


Comment:

 strk sadly I confirmed but I'm pushing this.  But my windows box is faster
 than your Linux box )--


 {{{
 -- POSTGIS="2.1.8 r13780" GEOS="3.5.0-CAPI-1.9.0 r4090" PROJ="Rel. 4.8.0,
 6 March 2012" GDAL="GDAL 1.11.1, released 2014/09/24" LIBXML="2.7.8"
 LIBJSON="UNKNOWN" TOPOLOGY RASTER

 Timing is:
 -- 4MB work_mem
 SELECT 155590/1000/60 - 2 min
 }}}

 {{{
 -- POSTGIS="2.2.0dev r14180" GEOS="3.5.0-CAPI-1.9.0 r4090" PROJ="Rel.
 4.9.1, 04 March 2015" GDAL="GDAL 2.0.1, released 2015/09/15"
 LIBXML="2.7.8" LIBJSON="0.12" TOPOLOGY RASTER (raster lib from "2.2.0dev
 r14198" need upgrade)

 SELECT 391802/1000/60 6min -- work_mem 4MB -- 2.2.0
 SELECT 387853/1000/60 - 6 min -- work_mem 500MB -- 2.2.0
 }}}


 so sadly even upping the work mem didn't seem to help things mcuh.

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