[MacPorts] #67044: Registry DB is 1.2GB and makes a 10.4.11 system unusable

[MacPorts]

#67044: Registry DB is 1.2GB and makes a 10.4.11 system unusable
-------------------------+--------------------
  Reporter:  evanmiller  |      Owner:  (none)
      Type:  defect      |     Status:  new
  Priority:  Normal      |  Milestone:
 Component:  base        |    Version:  2.8.1
Resolution:              |   Keywords:
      Port:              |
-------------------------+--------------------

Comment (by evanmiller):

 Replying to [comment:7 ryandesign]:
 > The size of the registry should be proportional to the amount of data in
 it, which would depend on how many ports you have installed, how many
 files those ports install, and so on. For example, on one of my machines
 running Monterey with 960 ports installed, my registry.db is 117MB. How
 many ports do you have installed? Do any of them contain a very large
 number of files? You should be able to reduce the size of the registry by
 installing inactive ports and any other ports you don't need.

 I was able to reduce the size of the registry DB to 80MB with {{{port
 uninstall inactive}}}. The other steps seem to be necessary to prevent the
 overall OS memory leak – maybe the OS is backing both files in Inactive
 memory for some reason?

 I would suggest not setting {{{needs_vacuum}}} every time something is
 deleted from the registry, which is the current behavior. Vacuum appears
 to rewrite the entire registry database, once to the WAL file, and then to
 the actual DB file. Previously this was resulting 1.2 GB of disk writes
 for many everyday {{{port}}} commands.

-- 
Ticket URL: <https://trac.macports.org/ticket/67044#comment:8>
MacPorts <https://www.macports.org/>
Ports system for macOS