[PostGIS] #5798: Out of memory: Killed process

[PostGIS]

#5798: Out of memory: Killed process
--------------------------------+---------------------------
  Reporter:  Lars Aksel Opsahl  |      Owner:  strk
      Type:  defect             |     Status:  reopened
  Priority:  medium             |  Milestone:  PostGIS 3.5.1
 Component:  topology           |    Version:  3.4.x
Resolution:                     |   Keywords:
--------------------------------+---------------------------
Comment (by Lars Aksel Opsahl):

 After the memory fixes up to
 [https://git.osgeo.org/gitea/postgis/postgis/commit/75d9b03d6c4ec5d47637f9912081f4eaf332810e]
 the test that failed here are now running through with out any memory
 errors.

 Yes I run very low on memory but the code runs through with out any memory
 errors.

 I was now testing with 100 threads in parallel and 1300 max 1300 rows pr
 cell.

 {{{


 CALL topo_rog_static.rog_overlay(
    ARRAY[
 'sk_grl.n5_forvaltning_flate n5',
 'prod_dyrkbarjord_05.snapshot_ar5_flate ar5',
 'prod_dyrkbarjord_05.snapshot_ssb_flate ssb',
 'prod_dyrkbarjord_05.snapshot_mdir_flate mdir',
 'prod_dyrkbarjord_05.snapshot_dmk_flate dmk',
 'prod_dyrkbarjord_05.snapshot_ravine_dtm10_dmk_flate dtm10',
 'prod_dyrkbarjord_05.snapshot_ravine_statsforvalter_flate ravine'
    ],
    'tmp_dyrkbarjord_12.dyrkbarjord_05',
    4258, --srid
    0, -- no snapto
    10.0, -- min m2 area to keep
    0, --max vertx length
    false, -- _break_up_big_polygons
    1.0, -- min negative buffer value null, remove sliver polygons
    ARRAY[
 ('0103000020A21000000100000005000000B3C573C549A82240C2497FD1316F4F40B3C573C549A8224059E5729B33DC4F40A3DA057EEABE264059E5729B33DC4F40A3DA057EEABE2640C2497FD1316F4F40B3C573C549A82240C2497FD1316F4F40','037')::rog_input_boundary::rog_input_boundary
   ]
    , -- run all the area blocks
    true, -- do_qualitycheck_on_final_reseult
    --  Method 1 topology.TopoGeo_addLinestring
    --  Method 2 topology.TopoGeo_LoadGeometry
    --  Method 3 select from tmp toplogy into master topology
    3,
    100, -- _max_parallel_jobs int, -- this is the max number of paralell
 jobs to run. There must be at least the same number of free connections
    1300, -- _max_rows_in_each_cell int, -- this is the max number rows
 that intersects with box before it's split into 4 new boxes
    null
    );

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