Comment by asa400 Comment by asa400 2 days ago 2 replies Copy Link View on Hacker News Are you running vacuums at all? auto_vacuum enabled at all?https://sqlite.org/lang_vacuum.html
Copy Link porridgeraisin 2 days ago Collapse Comment - In memory DBs don't have anything to vacuum.However... what you (and OP) are looking for might be pragma shrink_memory [1].[1] https://sqlite.org/pragma.html#pragma_shrink_memory Reply View | 1 reply Copy Link asa400 2 days ago Parent Collapse Comment - Ah, you're correct. I read too fast and missed that it was in-memory databases specifically! Reply View | 0 replies
Copy Link asa400 2 days ago Parent Collapse Comment - Ah, you're correct. I read too fast and missed that it was in-memory databases specifically! Reply View | 0 replies
In memory DBs don't have anything to vacuum.
However... what you (and OP) are looking for might be pragma shrink_memory [1].
[1] https://sqlite.org/pragma.html#pragma_shrink_memory