Hi Dinu,
So, to make an architectural decision, can you tell me if CREATE DB is running in quasi-constant space?
If you create new databases, it’s mostly the indexing of texts and attributes that requires additional memory. Memory usage is not constant, but the standard value indexes will automatically write temporary data structures to disk if your memory gets low. If you disable the text and attribute index, you can build initial databases from input up to 500 GB [1].
Cheers, Christian