Re:Bug Hunting in Btrfs
by eru on Wednesday March 20, 2024 @10:52AM
(#39767459)
Interesting. The compression options that postgres offers itself were not enough?
[ Parent
| on HN ]
Re:Bug Hunting in Btrfs
by yjftsjthsd-h on Wednesday March 20, 2024 @11:08AM
(#39767697)
It went the other way; we were using ZFS to protect against data errors, then found that it did compression as well. But looking now, the only native postgres options I see are TOAST, which seems to only work for certain data types in the database, and WAL compression (that's only existed since pg 15), so unless I've missed something I would tend to say yes it's far superior to the native options.
I mostly only looked into the options offered by MariaDB a while ago, and they seemed quite neat. I had just assumed that postgres was at least on par.
Thanks for reporting!