is there a way to shrink or even disable the spot index? long running program, lots of transactions, don't want to run out of memory
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 🤔
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