News for hackers. Stuff that matters.
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?
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.
Re:Bug Hunting in Btrfs by eru on Wednesday March 20, 2024 @08:47PM (#39773786)
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!

Re:Bug Hunting in Btrfs by riku_iki on Wednesday March 20, 2024 @04:15PM (#39771492)
postgres allows to compress only large text and blob column values.