Untitled attachment

Notices where this attachment appears

1. Embed this notice
   Howard Chu @ Symas (hyc@mastodon.social)'s status on Friday, 08-Nov-2024 02:41:10 JST Howard Chu @ Symas

   in reply to

   "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.