Arch Linux using a custom LVM + Btrfs + Ext4 for database.Ubuntu as setup by the VPS provider ( virtio-scsi).Arch Linux using its official cloud image (Btrfs, no compression, has metadata and system DUP, noatime, autodefrag, virtio-block).Include connection establishing, rounded, higher is better. Tests were run using a raw preallocated image on a SSD Btrfs filesystem. Filesystem tuned similarly to Linux but without changing primarycache setting according to.ZFS tuned for Postgresql according to the arch wiki.However, Btrfs and ZFS were tuned for a database as one would normally do. I used these instructions to benchmark Postgresql, it’s a basic benchmark with 10 and 100 clients. First, the tests were run locally in a VM configured close to the specs of the VPS I was planning to use. Then there is ZFS, which is used by FreeBSD for good reasons (its previous filesystem UFS is about as good as Ext2) and is also promoted by Ubuntu these days. So I was curious, not whether Btrfs would outperform Ext4 and XFS but rather if it’s a viable choice. However in that case database performance is often the limiting factor.
0 Comments
Leave a Reply. |