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

Spreadsolana.com, databases, open source, community, remote.

Previously: 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?

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

While I don't think the issues you raise are inconsequential, I also know that corruption bugs exist in xfs/ext4. I think Ubuntu has made it first class, ya?

Do you know of a more comprehensive post outlining the dangers of ZFS on Linux? Has there been a notable shop that has stopped using it?

I know that Heap Analytics ran close to a PB on PG/ZFS/Linux and I think they still do. ¯\_(ツ)_/¯ 

I'm not ZFS maxxing. I genuinely want to find a good reason not to use it.

While I don't think the issues you raise are inconsequential, I also know that corruption bugs exist in xfs/ext4. I think Ubuntu has made it first class, ya?

Do you know of a more comprehensive post outlining the dangers of ZFS on Linux? Has there been a notable shop that has stopped using it?

I know that Heap Analytics ran close to a PB on PG/ZFS/Linux and I think they still do. ¯\_(ツ)_/¯ 

I'm not ZFS maxxing. I genuinely want to find a good reason not to use it.

https://news.ycombinator.com/item?id=18048984

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