[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):

 Replying to [comment:7 strk]:
 > If I understand the message correctly PostgreSQL autovacuum process is
 unable to allocate new memory for the TopTransactionContext memory pool.
 This isn't necessarely due to a leak, it could also "just" be higher
 memory consumption. To find a leak you should run a single process and see
 if the memory of that process keeps raising.

 This has not been an problem before.

 sysctl -w vm.overcommit_memory=0
 vm.overcommit_memory = 0

 I now run a test with 10 threads in parallel .

 And started out with


 {{{
 Wed Oct 16 12:08:54 CEST 2024
                total        used        free      shared  buff/cache
 available
 Mem:           125Gi       4.1Gi       100Gi       3.3Gi        20Gi
 117Gi
 Swap:          7.8Gi       258Mi       7.6Gi

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