The postgres team is advocating that compression should be applied the file system, and they are correct. But this won‘t solve the problem if filesystem compression is not widely available. ZFS and BTRFS are not widely used, the first one because of licenses the last one because of bad pr in the past.

You can add VDO to the LVM stack but thats another layer in the complex ext4/xfs lvm layering approach.