[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