4 ms·
The problem with btrfs is that is does not work well with databases without careful adjustment. https://archive.ph/dqFgh https://archive.ph/dqFgh
by chasil 2y ago
The problem with btrfs is that is does not work well with databases without careful adjustment.
https://archive.ph/dqFgh https://archive.ph/dqFgh
- anotherhue 2y agoZFS also but I don't think this applies to SQLite, more to 'real' DBs like PSQL.
- chasil 2y agoThere is an Oracle zfs tuning guide for the eponymous database. I would look at that if I wanted good performance for postgres or sqlite. https://docs.oracle.com/cd/E36784_01/html/E36845/chapterzfs-db2.html https://docs.oracle.com/cd/E36784_01/html/E36845/chapterzfs-... Google also returned zfs general database tuning: https://docs.oracle.com/en/operating-systems/solaris/oracle-solaris/11.4/tuning/tuning-zfs-database-products.html https://docs.oracle.com/en/operating-systems/solaris/oracle-...