Why the hell is Core still stuck on LevelDB anyway?
RocksDB Features that are not in LevelDBRocksDB is way more advanced and allows much finer control on how to store/compress/read data.
You can store tx older than 1 year with profile optimized for space efficiency (huge compression), because they have the least chance of being read during normal operation.
Then store recent tx with profile optimized for read and write, no compression.
LevelDB has similar features but RocksDB is far more advanced.
Saves at least 10-20G out of a 150G blockchain just by switching.
When the blockchain reaches 2TB-100TB, use two RocksDB profiles, one for SSD, and one for mechanical disks, store recent years on SSD, older years on mechanical disks, mirror/raid the disks if you have to.