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

[PostGIS]

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

 When running with POSTGIS="3.6.0dev 3.5.0-48-g75d9b03d6" I got this error.
 I need to retest this.


 {{{
 >ERROR:  cache lookup failed for type 15857891
 /var/log/postgresql/postgresql-Sun.log.1:       ' , using conn
 'conn_3813f3afc65243dc84261ac1bfcdfca0_1', state  : 'XX000' message:
 'cache lookup failed for type 15857891' detail : '' hint : '' context:
 'PL/pgSQL assignment "result =
 (inputLineEdgeIds,failed_line,face_edges_to_remove_list,_table_input_order,_src_table_pk_column_value,new_line,selected_edge_face_id)"


 }}}

 Below is the log from sar I see now  big changes in memory usage.

 {{{
 06:30:00    kbmemfree   kbavail kbmemused  %memused kbbuffers  kbcached
 kbcommit   %commit  kbactive   kbinact   kbdirty
 09:20:03     46870604  63678672    964888      1.47      7648  17284504
 11140752     15.04   4167800  13616408        12
 09:30:02     54351468  61472872   1873832      2.85      7648   8881104
 12203724     16.48   3478428   6845296     71228
 09:40:03     54060728  61178664   1959712      2.98      7648   9061380
 12277336     16.58   3931872   6653236     56692
 09:50:03     54711104  61097120   1918060      2.91      7648   8439672
 12248920     16.54   4266792   5664344     54144
 10:00:01     52944848  59890084   2431672      3.69      7648   9684532
 12721888     17.18   4855788   6823912     70692
 10:10:03     52787460  59454200   2868928      4.36      7648   9399136
 13156584     17.76   5115464   6714596     69132
 10:20:03     53129960  59953140   2368436      3.60      7648   9543828
 12665064     17.10   5148836   6324272     65856
 10:30:01     52310940  59273088   3049248      4.63      7648   9673892
 13336024     18.01   5191960   7076380     60728
 10:40:03     52596996  59667752   2515028      3.82      7648   9914588
 12799180     17.28   5372904   6593484     86952
 10:50:03     52426232  59606796   2446672      3.72      7648  10147756
 12736424     17.20   5531712   6614168     45972
 11:00:03     51883252  59239916   2616252      3.97      7648  10512920
 12925556     17.45   5723168   6960980    105172
 11:10:03     52036312  59419436   2306020      3.50      7648  10662740
 12610384     17.03   5928948   6596164     88712
 11:20:03     51280996  58913852   2694360      4.09      7648  11020636
 12973156     17.52   6060100   7206428     85928
 11:30:03     51025856  58745296   2818520      4.28      7648  11143464
 13103884     17.69   6140960   7357568     54288
 11:40:01     50466424  58236232   3224400      4.90      7648  11288644
 13495192     18.22   6274660   7775044     93132
 11:50:03     46446228  55125096   5304776      8.06      7648  13217260
 15581204     21.04   6904708  11144952    120416
 12:00:00     45610136  54602196   5497288      8.35      7648  13859348
 15707692     21.21   7494788  11377356     44188
 12:10:03     44237648  53522212   6236368      9.47      7648  14490436
 16397884     22.14   7958108  12270112     74448
 12:20:03     43445796  53091948   6220168      9.45      7648  15294224
 16391312     22.13   8394292  12622436     60064
 12:30:03     43492280  53229880   5805956      8.82      7648  15660896
 15975884     21.57   8675324  12300800     24412
 12:40:03     43594052  53222528   5817408      8.84      7648  15549396
 16049928     21.67   8717608  12155880     22116
 12:50:03     39943508  50632364   7559464     11.48      7648  17449480
 17776788     24.00   9077192  15427732     96372
 13:00:04     39013616  50327196   7371292     11.20      7648  18562680
 17549968     23.69   9853320  15544592     97144

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