2023-10-06, 03:57 PM
Having your database on a ZFS file system is possible, it is very much not recommended. Database READ performance is fine, but when you are writing to a database that is on a ZFS file system there are serious performance penalties.
And because your database is big, that adds to the performance penalty.
If possible, move your database to an EXT4 file system.
And because your database is big, that adds to the performance penalty.
If possible, move your database to an EXT4 file system.