On 25 November 2015 at 10:27, Vojtěch Zeisek
Hello, recently I saw (on Czech Linux days, so no useful reference for here;-) presentation testing performance of PostgreSQL on various Linux FS (on SSD). Performance of Ext4 and XFS were more or less the same. But Btrfs failed. Possibly this is because of copy-on-write, which can be turned off. In such case its performance is better, but still little bit loosing. I'd like to use Btrfs, especially because of its snapshot feature, but I wonder what is the best FS for /var/lib/{mysql,pgsql} on SSD. Do people have Btrfs subvolumes with COW turned off? Any extra tuning? Or rather separate partitions (but it would be bit uncomfortable for resizing, yes, LVM, but might be too complicated architecture then...) with Ext4/XFS? Any other ideas? Thanks in advance, Vojtěch
-- Vojtěch Zeisek
Komunita openSUSE GNU/Linuxu Community of the openSUSE GNU/Linux
If you can partition accordingly, XFS is what I would recommend, and what YaST will give you if you tell it you want a data partition. However, if you only have the chance for one filesystem on disk, I'd agree with you that btrfs should be your choice as you get snapshotting, etc. btrfs on openSUSE Leap 42.1 and Tumbleweed automatically disable copy on write in the subvolumes it creates automatically for /var/lib/pgsql and /var/lib/mysql, and that will give you good performance -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org