3 ms·
Just running Postgres on an NVDIMM, or any other database for that matter, will give you a large speedup compared to normal storage, especially when you have st
by pbalcer 8y ago
Just running Postgres on an NVDIMM, or any other database for that matter, will give you a large speedup compared to normal storage, especially when you have strong durability requirements for a transaction (fsync() will be faster).
But to fully benefit from persistent memory, the DBMS will need to modified. To see how that might look, read this [0] post by Microsoft about their efforts in SQL Server.
There's also an interesting research paper from CMU [1] that talks about challenges associated with pmem in the context of databases.
[0] - https://blogs.msdn.microsoft.com/bobsql/2016/11/08/how-it-works-it-just-runs-faster-non-volatile-memory-sql-server-tail-of-log-caching-on-nvdimm/ https://blogs.msdn.microsoft.com/bobsql/2016/11/08/how-it-wo...
[1] - https://www.cs.cmu.edu/~jarulraj/papers/2015.storage.sigmod.pdf https://www.cs.cmu.edu/~jarulraj/papers/2015.storage.sigmod....