I know all of that. As an argument I must say the btrfs has the same, but it’s at least in 2-3 times faster than zfs in the same level of RAID.
I also tested the RAID10 in all three systems, as it’s the only viable RAID for production databases.
The results have not changed: LVM raid,
btrfs,
zfs
BUT.
Since LVM raid have no checksum checks, and btrfs is unstable, there is no other choice. Maybe only Ceph.
the same for LVM snapshots (with extension like GitHub - davidbartonau/lvm-thin-sendrcv: Send and receive incremental / thin LVM snapshots on a live volume. Replication / synchronisation of an LVM volume to a remote server by transmitting only the difference between snapshots of a live / running volume.), btrfs snapshots. So, no win here.
I second that.
But still - it’s slow. You just need to account that into considerations and make changes accordingly.