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

 I've made the following changes locally and have a usable installation
 again:

 * Disable {{{needs_vacuum}}} – this avoids writing out a 600MB WAL file
 any time something is deleted from the registry. The current vacuum policy
 is probably too aggressive given the cost of the operation.
 * Disable {{{fullfsync}}}
 * Change {{{SQLITE_CHECKPOINT_PASSIVE}}} to
 {{{SQLITE_CHECKPOINT_TRUNCATE}}}

 I'll leave the information here in case others find it useful and will
 prep a PR if I think it can be generalized.

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