Scaling to billions of facts?

General
19

(more than would fit in the largest available memory)

You may be interested in TigerBeetle’s architecture. All memory is statically allocated at startup and they just work with IO to disk.