Hacker News Reader

Comment by chasil | Hacker News Reader

Btrfs is able to do one important thing that ZFS cannot: defragment.

I see XFS as the performance leader (appears on TPC.org the most often that I can see), btrfs as the fullest featured, and ZFS with the strongest reliability.

View on HN

XFS is the best filesystem for people who don't want to deal with filesystems. Btrfs is there for the rest of us.

As far as that goes, Oracle prohibits the installation of their database on btrfs (note 2290489.1: "Oracle DB has specifically said that they do not support using BTRFS filesystems... BTRFS is optimized for non-database workloads.").

XFS for databases is what is used on tpc.org, but perhaps these new improvements may help.

Unfortunately, as best as I can tell you can’t shrink an XFS volume other than by completely rewriting it. (Also mkfs.xfs formats with Y2038-susceptible 32-bit timestamps by default, but that can be overriden.)

RedHat 8 and clones began creating safe XFS timestamps in their installers.

I think they are safe with this version:

  XFS (sda1): Mounting V5 Filesystem

That's incorrect, you can defrag with

    btrfs filesystem defragment /path

There is also the mount option autodefrag

Reread the comment you replied to. Slowly.

Reply on news.ycombinator.com