Embed Notice

"LMDB doesn't support vacuum, DB file can only grow"

https://x.com/Horusiath/status/1854043603942748162

Other DBs like SQLite and MySQL etc need vacuum because they don't have true delete operations. Their delete just sets a flag on a record, making it a "tombstone", but leaves the record intact in the DB. All these tombstones accumulate over time and must be periodically vacuumed to keep the DB from growing infinitely.

LMDB actually deletes records immediately, it doesn't use tombstones, so it needs no vacuum.