PostgreSQL

Damn.

Screen shot from this talk on PG/ZFS

Damn.

Screen shot from this talk on PG/ZFS

https://people.freebsd.org/%7Eseanc/postgresql/scale15x-2017-postgresql_zfs_best_practices.pdf

though, zfs support on various linux distributions is still iffy. i think its quite largely/widely used in freebsd land, over ufs2. some MySQL installs run zfs too, though i think most of the production ready large scale ones are on xfs or ext4

databases, open source, community, remote.

Previously: early at mysql, co-founder mariadb server

I think it’s because it’s not mainline in every distribution, which is the issue. 

Recovery is a bit problematic. 

And then, you’ll find random bugs like

I think it’s because it’s not mainline in every distribution, which is the issue. 

Recovery is a bit problematic. 

And then, you’ll find random bugs like https://discourse.practicalzfs.com/t/openzfs-2-2-data-corruption-bug-patched/1117

I've been a longtime user of XFS with basically 0 problems. But I do wonder if compression can help with disk size and seq/index scan performance (trading CPU)

I've also felt the "ZFS on Linux" is not a good idea vibe. But I'm struggling to find an exact explanation of why. Do you have some links to share that could help me understand the pitfalls of ZFS on Linux?