4 ms·

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 qui

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?

jdhawk 5y ago
They state it. Compression
- Aachen 5y ago
  Even NTFS has compression, so it doesn't seem to be that simple.
  - jdhawk 5y ago
    goodness. read the article. LZX is not close to LZ4, which is not close to ZSTD.
jhk727 5y ago
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.
- nhoughto 5y ago
  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
  - jhk727 5y ago
    It was a nontrivial improvement to write throughput at the time. I'd imagine it could have similar impact for other write-intensive workloads.
toast0 5y ago
Data integrity is nice to have.