Hi Michael,

On Sun, Jun 18, 2023 at 01:36:30PM +0200, Michael J Gruber wrote:
> On my comparatively small db, gains are typically substantial
> (postlist, position), even though I compact from time to time.

Thanks for your help. The savings were indeed a lot more than I
expected (and the compact didn't take anywhere near as long as I
thought it would, either):

$ sudo compsize ~/.notmuch
Processed 7 files, 5159972 regular extents (5484004 refs), 2 inline.
Type       Perc     Disk Usage   Uncompressed Referenced  
TOTAL       60%       51G          85G          56G       
none       100%       18G          18G          16G       
zstd        49%       32G          66G          39G
$ notmuch compact
Compacting database...
compacting table postlist
     Reduced by 62% 8838736K (14138192K -> 5299456K)
compacting table docdata
     Reduced by 50% 1168K (2304K -> 1136K)
compacting table termlist
     Reduced by 51% 6816008K (13112728K -> 6296720K)
compacting table position
     Reduced by 54% 17223112K (31731384K -> 14508272K)
compacting table spelling
     doesn't exist
compacting table synonym
     doesn't exist
Done.
$ sudo compsize ~/.notmuch
Processed 7 files, 186246 regular extents (187018 refs), 2 inline.
Type       Perc     Disk Usage   Uncompressed Referenced  
TOTAL       56%       14G          25G          25G       
none       100%      3.7G         3.7G         3.7G       
zstd        48%       10G          21G          21G

I don't know why so much space should have been saved, though it may
be something to do with the fact that I indexed everything and then
decided to move a million or so messages around into a different
folder structure.

Thanks,
Andy

-- 
https://bitfolk.com/ -- No-nonsense VPS hosting
_______________________________________________
notmuch mailing list -- notmuch@notmuchmail.org
To unsubscribe send an email to notmuch-leave@notmuchmail.org