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

[PostGIS]

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

 I have now set vm.overcommit_memory=2 and run test with only 100 workes
 and it still seems like free memory is steadly falling.

 In this run we create around 1300 topologies with more 65. million edges
 and more than 3.5 million faces generted from 7 different simple feature
 input tables. Each of this 1300 topologies  are cleaned up by removing
 faces below 10 m2 . We then reduce the number edges to around 5 millon
 edges and faces down to below 1 million faces, before it’s moved into
 single a topology.

 When started free memory was around 100 GB. We are now done with 1250 of
 the temp toplogies and free memory is now


 {{{
 Wed Oct 16 09:35:28 CEST 2024
                total        used        free      shared  buff/cache
 available
 Mem:           125Gi        57Gi        30Gi       8.3Gi        37Gi
 58Gi
 Swap:          7.8Gi       259Mi       7.6Gi

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