[sqlite] LSM database file growth?

Is the LSM database append-only, as in the file size will always grow/never shrink (even if there are deletions/overwrites)? Thanks! ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinf

Re: [sqlite] LSM database file growth?

On 10/31/2017 10:50 PM, Charles Leifer wrote: Is the LSM database append-only, as in the file size will always grow/never shrink (even if there are deletions/overwrites)? An LSM database is basically a series of tree structures on disk. When you write to an LSM database you add the new key to

Re: [sqlite] LSM database file growth?

Thanks so much, this explains things neatly. I was aware of the tree compaction and the use of delete tombstones, but wasn't sure how it all played out in terms of space reclamation. In other words, if the total size of my keyspace is fixed, then the database won't grow without bounds, even if keys