[PostGIS] #5808: Weird constant ram increase using topology

PostGIS trac at osgeo.org
Tue Nov 5 17:42:12 PST 2024


#5808: Weird constant ram increase using topology
-----------------------+---------------------------
  Reporter:  latot     |      Owner:  strk
      Type:  defect    |     Status:  new
  Priority:  medium    |  Milestone:  PostGIS 3.5.1
 Component:  topology  |    Version:  3.5.x
Resolution:            |   Keywords:
-----------------------+---------------------------
Comment (by Lars Aksel Opsahl):

 Memory seems to be released as we see here some hours later for postgres

 {{{

 48161  postgres         0.0  00:00.06 1       0    8      2977K 0B
 1344K 48161 48153 sleeping *0[1]        0.00000 0.00000    501 557
 64       10         5          2604       25         539        0        2
 0.0   0      0      lop                   N/A    N/A   N/A   N/A   N/A
 N/A
 48160  postgres         0.0  00:00.63 1       0    8      3457K 0B
 1568K 48160 48153 sleeping *0[1]        0.00000 0.00000    501 528
 66       10         5          18922      62         5222       0
 17        0.0   0      0      lop                   N/A    N/A   N/A   N/A
 N/A   N/A
 48159  postgres         0.0  00:00.30 1       0    8      6113K 0B
 2656K 48159 48153 sleeping *0[1]        0.00000 0.00000    501 1273
 60       11         5          9809       16         11657      0
 115       0.0   0      0      lop                   N/A    N/A   N/A   N/A
 N/A   N/A
 48157  postgres         0.0  00:00.12 1       0    8      5313K 0B
 3872K 48157 48153 sleeping *0[1]        0.00000 0.00000    501 576
 56       10         5          5536       17         5702       0
 50        0.0   0      0      lop                   N/A    N/A   N/A   N/A
 N/A   N/A
 48156  postgres         0.0  00:00.73 1       0    8      17M   0B
 8800K 48156 48153 sleeping *0[1]        0.00000 0.00000    501 2760
 77       12         5          14196      69         6394       2
 116       0.0   0      0      lop                   N/A    N/A   N/A   N/A
 N/A   N/A
 48153  postgres         0.0  00:02.98 1       0    22     15M   0B    12M
 48153 1     sleeping *0[1]        0.00000 0.00000    501 195965    89939
 10386      5180       70156      5419       15276      78       1
 0.0   0      0      lop                   N/A    N/A   N/A   N/A   N/A
 N/A

 }}}

 The pattern seems to be normal run a job and postgres takes some memory
 and wait some time and memory is released.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5808#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.


More information about the postgis-tickets mailing list