To add to this thread, some people have done this exploration before, see slides 11 and 20 of [0] or Figure 1 of [1]. Could you just throw more RAM at your prob

To add to this thread, some people have done this exploration before, see slides 11 and 20 of [0] or Figure 1 of [1]. Could you just throw more RAM at your problems in a disk-backed system? In practice, probably. But there are distinct advantages to designing upfront for an in-memory scenario. [0] https://15721.courses.cs.cmu.edu/spring2020/slides/02-inmemory.pdf https://15721.courses.cs.cmu.edu/spring2020/slides/02-inmemo... [1] https://15721.courses.cs.cmu.edu/spring2020/papers/02-inmemory/hstore-lookingglass.pdf https://15721.courses.cs.cmu.edu/spring2020/papers/02-inmemo...