Some people do Postgres on compressed ZFS volumes to great success.
On average I get around 4x compression on PostgreSQL data with zstd-1
I am curious if you know anyone using Btrfs for this too. I like ZFS, but it Btrfs can do this it would be easier to use with some distros, etc. as it's supported in kernel.
On average I get around 4x compression on PostgreSQL data with zstd-1