maintainer-feedback requested: [Bug 276931] ports-mgmt/pkg: writes big journal files

Bugzilla Automation <bugzilla@FreeBSD.org> has asked freebsd-pkg (Nobody)
<pkg@FreeBSD.org> for maintainer-feedback:
Bug 276931: ports-mgmt/pkg: writes big journal files
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=276931



--- Description ---
Scenario:
- FreeBSD stable/14 as of today
- ports latest

Result:
- It seems that since some days pkg(8) has started to create huge journal files
in /var/db/pkg whenever a package is deleted or added:

[0]# ll /var/db/pkg
total 45617
-rw-r--r--  1 root wheel 71303168 Feb  9 20:34 local.sqlite
-rw-r--r--  1 root wheel 71349200 Feb  9 20:34 local.sqlite-journal

- This leads to a massive slowdown if many packages are installed separately
and the storage is not very fast. In fact, for all but the bigget packages,
writing the journal file now by far dominates the time it takes to delete or
add a package.

Expected result:
- As before, pkg operations should be fast.

-- Martin