Hi @asg017
One of my SQLite DB with sqlite_vec has grown to 3.7GB in size, since frequent writes and deletions in my application, but the SQLite file size doesn’t automatically shrink.
I tried the VACUUM command, but it only reduced the size from 3.7GB to 3.2GB, not significant. I’m certain that the current embedding database contains far fewer rows—only 80,000 rows of 1024-dim float32 vectors.
But I checked sqlite_sequence, and the vec_items_rowids count is 770,000+.
I’d like to know how I can further reduce the size of my database.
Hi @asg017
One of my SQLite DB with
sqlite_vechas grown to 3.7GB in size, since frequent writes and deletions in my application, but the SQLite file size doesn’t automatically shrink.I tried the
VACUUMcommand, but it only reduced the size from 3.7GB to 3.2GB, not significant. I’m certain that the current embedding database contains far fewer rows—only 80,000 rows of 1024-dimfloat32vectors.But I checked
sqlite_sequence, and thevec_items_rowidscount is 770,000+.I’d like to know how I can further reduce the size of my database.