4 ms·
You might use such a thing in database systems for, eg: 1. The write ahead log, for faster I/O than a direct flush to SSD 2. Staging disk cache entries to pers
by haimez 5y ago
You might use such a thing in database systems for, eg:
1. The write ahead log, for faster I/O than a direct flush to SSD
2. Staging disk cache entries to persistent memory before a planned host/process restart for faster subsequent DRAM cache warming
The problem with 1 is that you still need to periodically flush to disk (at least once persistent storage is full) which means it’s only an improvement in burst activity and not peak throughput.
The problem with both is complexity of implementation to deliver functionality that can only be used on a (currently) relatively uncommon subset of servers. Probably not something that Postgres would rush to implement, but potentially something that MSSQL or Oracle might consider as a premium feature.
Disclaimer: I haven’t looked into the details of optane and how you interface with that storage in software.