Hi Andy, I'm really glad the compaction was so successful! I think the Xapian folks deserve the big credit for this, more than any code specific to notmuch, (other than user interface and safety checking/backup, etc.). I'm really glad you're finding notmuch helpful. And I'm glad you felt comfortable reaching out for guidance. Enjoy your new hard drive space! -Carl On Sun, Jun 18 2023, Andy Smith wrote: > 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 _______________________________________________ notmuch mailing list -- notmuch@notmuchmail.org To unsubscribe send an email to notmuch-leave@notmuchmail.org