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.
I'm not sure page level compression can get efficiency of LSM-Tree, and frequent page writes will be a write amplification problem if you end up doing any form of copy-on-write and try to do in-place overwrites.
You can add VDO to the LVM stack but thats another layer in the complex ext4/xfs lvm layering approach.