4 ms·
> so might increase your compute cost without any storage savings. I agree with this point, but I think those online compression algorithms add very little ove
by riku_iki 3y ago
> so might increase your compute cost without any storage savings.
I agree with this point, but I think those online compression algorithms add very little overhead, so it is mostly about if Postgres adds enough other benefits compared to your current DB.
The bigger issue potentially is that ext4 is faster than zfs and btrfs itself regardless of compression.
- abhibeckert 3y agoThe compression penalty is actually massive. The bytes you're trying to read might require reading other bytes elsewhere on the disk in order to decompress them. It's not just compute power, I was generalising with that statement. The real world speed hit can be as bad as read speeds an order of magnitude slower than if you disable compression. You really only want to compress data where it makes sense to compress it.
- riku_iki 3y ago> The bytes you're trying to read might require reading other bytes elsewhere on the disk in order to decompress them. data is compressed and decompressed in blocks..