R&D: NVM, Is It not Very Meaningful for Databases?
Using PMEM as persistent storage usually speeds up query execution, but with some caveats as I/O path is not fully optimized and therefore does not always justify additional cost
This is a Press Release edited by StorageNewsletter.com on December 21, 2023 at 2:00 pmACM Digital Library has published, in Proceedings of the VLDB EndowmentVolume 16 Issue 10, an article written by Dimitrios Koutsoukos, Raghav Bhartia, Michal Friedman, Ana Klimovic, and Gustavo Alonso, ETH Zurich, Switzerland.
Abstract: “Persistent or Non Volatile Memory (PMEM) offers expanded memory capacity and faster access to persistent storage. However, there is no comprehensive empirical analysis of existing database engines under different PMEM modes, to understand how databases can benefit from the various hardware configurations. To this end, we analyze multiple different engines under common benchmarks with PMEM in AppDirect mode and Memory mode. Our results show that PMEM in Memory mode does not offer any clear performance advantage despite the larger volatile memory capacity. Also, using PMEM as persistent storage usually speeds up query execution, but with some caveats as the I/O path is not fully optimized and therefore does not always justify the additional cost. We show this to be the case through a comprehensive evaluation of different engines and database configurations under different workloads.“