Can somebody enlighten me on why you would use ZFS for DB?, seems like there would be overlap/conflict of features. The only benefit that I know of would be quick restore to previous state, but how often would you need to restore?
Author here - It's explained in the post but the primary driver is cost. 80%+ reduction in storage is massive when you're storing petabytes of data on ssds.
how important was being able to disable postgres full page writes under zfs? that was almost a throw-away line in the article but could be really important for some pg workloads i'd think? certainly got my attention
It was a nontrivial improvement to write throughput at the time. I'd imagine it could have similar impact for other write-intensive workloads.
Data integrity is nice to have.
They state it. Compression
Even NTFS has compression, so it doesn't seem to be that simple.
goodness. read the article. LZX is not close to LZ4, which is not close to ZSTD.