You can’t disable the spot index. It’s probably the most important one. It would be possible to add a feature to snapshot an in-memory DB to only hold the most recent (or n most recent) transaction points. It will have to be a new feature though. You’d probably want to drop the tspo index as well :thinking_face:

For now, I suggest copying a db into another DB and throwing away the first one. The copy only has the latest transaction, and the original can be GC’d.

Of course, that needs a temporary expansion of memory use. But avoiding that will need a new API, so it’s the best I can suggest for now