4 ms·
Interesting. The compression options that postgres offers itself were not enough?
by eru 3y ago
Interesting. The compression options that postgres offers itself were not enough?
- yjftsjthsd-h 3y agoIt 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.
- eru 3y agoI 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!
- riku_iki 3y agopostgres allows to compress only large text and blob column values.