asami

nivekuil 2023-11-06T19:34:42.244549Z

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

quoll 2023-11-06T21:30:54.086269Z

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 🤔

quoll 2023-11-06T21:32:03.211149Z

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.

👍 1
quoll 2023-11-06T21:38:34.817599Z

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