Hacker News new | ask | show | jobs
by olavgg 94 days ago
You are correct that writes are not guaranteed to be atomic. PostgreSQL has a feature to handle torn pages: full_page_writes = on, which is enabled by default. This means you do double write.

For RocksDB I believe torn pages are not a problem as SST files are immutable. But correct me if I am wrong.