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

Here is the actual talk: https://www.youtube.com/watch?v=T_1Zo4m4v_M

databases, open source, community, remote.

Previously: early at mysql, co-founder mariadb server

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?

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