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

https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=276931

            Bug ID: 276931
           Summary: ports-mgmt/pkg: writes big journal files
           Product: Ports & Packages
           Version: Latest
          Hardware: Any
                OS: Any
            Status: New
          Severity: Affects Only Me
          Priority: ---
         Component: Individual Port(s)
          Assignee: pkg@FreeBSD.org
          Reporter: d8zNeCFG@aon.at
          Assignee: pkg@FreeBSD.org
             Flags: maintainer-feedback?(pkg@FreeBSD.org)

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

-- 
You are receiving this mail because:
You are the assignee for the bug.