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

PostGIS trac at osgeo.org
Tue Nov 5 13:19:00 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):

 Tested this more than 30 times now on this setup

 {{{
 POSTGIS="3.5.0dev 3.4.0rc1-1272-g80806376a" [EXTENSION] PGSQL="160"
 GEOS="3.12.1-CAPI-1.18.1" PROJ="9.4.0 NETWORK_ENABLED=OFF
 URL_ENDPOINT=https://cdn.proj.org
 USER_WRITABLE_DIRECTORY=/Users/lop/Library/Application Support/proj
 DATABASE_PATH=/opt/homebrew/Cellar/proj/9.4.0/share/proj/proj.db"
 (compiled against PROJ 9.12.1) LIBXML="2.13.0" LIBJSON="0.17" TOPOLOGY
 }}}

 and I am not able to see this memory issue

 {{{

 PID    COMMAND      %CPU TIME     #TH     #WQ  #PORTS MEM    PURG   CMPRS
 PGRP  PPID  STATE    BOOSTS             %CPU_ME %CPU_OTHRS UID  FAULTS
 COW      MSGSENT     MSGRECV

 54567  postgres         0.0  00:11.39 1       0    8      294M  0B    94M
 54567 48153 sleeping *0[1]        0.00000 0.00000    501 20920     115
 10         5          137694     121        2387       233      0
 0.0   0      0      lop                   N/A    N/A   N/A   N/A   N/A
 N/A
 54566  psql             0.0  00:00.02 2       1    31     4977K 0B
 2368K 54566 1870  sleeping *0[1]        0.00000 0.00000    501 838
 111      62         19         2706       192        137        36       0
 0.0   0      0      lop                   N/A    N/A   N/A   N/A   N/A
 N/A
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5808#comment:3>
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