Currently about once a week due to https://github.com/lightningnetwork/lnd/issues/8250. I only run compaction at most once every two weeks, though. It's not worth it, as my databases are small enough (I use my own fix for the sphinxreplay.db bloat bug).