[daurnimator]

Note that Postgres has built in range types which makes much of this cleaner. See https://www.postgresql.org/docs/15/rangetypes.html#RANGETYPE...

[lichtenberger]

I guess Datomic is the most mature system, which uses a persistent in-memory index structure, mapped to a common on-disk storage system.

That said, nowadays it should probably be possible to store the persistent data structure in a log-structured file for instance and to make use of fast random-reads of enterprise PCIe SSDs without the indirection of another data store / index to traverse for each index page.