Battle testing PHP fopen, SQLite, PostgreSQL and MariaDB on #FFS2, #UFS, #ext4, #XFS and #ZFS, published: 20240122 modified: 20240123,
<could not find a name>
unixdigest.com/articles/battle…
@solene #OpenBSD 7.4 FFS2 fared better than #FreeBSD 14 UFS with #SoftUpdates (in the #powerCutTests).
This entry was edited (1 year ago)
Kyle Taylor
in reply to parvXtl • • •... If you combine your database with ZFS you have got a very strong system, especially when you run redundant drives. Of course you need to determine how to best set things up, and you better not do a snapshot in the middle of a database transaction, but that is not the subject of this article...
^^ My experience as well. I run postgres on ZFS in production and it's always been performant. Even under high load. Managing snapshots and pools is a little cumbersome, though.