> have huge working sets which would take too much memory, energy, and loading time to access.

even without resorting to new technologies, SSD are vey fast already, something which need much attention for out of core processing is the file formats, legacy formats and many new formats (!) are based on serialization of the whole file which goes against parallelization