beetbox / beets

music library manager and MusicBrainz tagger
http://beets.io/
MIT License
12.58k stars 1.8k forks source link

Beets does not vacuum the database resulting in very large db files #5150

Closed arsaboo closed 3 months ago

arsaboo commented 3 months ago

I was just looking at my beets files and realized that my database file had grown to 485,216 KB. On inspection, I realized that there were several empty/incomplete rows. I manually ran the VACUUM command on the database, and the file size was reduced by around 70% to 159,640 KB.

Given the frequent database updates that are required, it may be a good idea to add an option to clean up the DB.