4 ms·
What I learn is pipeing .dump into a new database can be faster than running vacuum for large database on btrfs. Example: (echo "pragma journal_mode=wal;" | s
by aabbcc1241 4y ago
What I learn is pipeing .dump into a new database can be faster than running vacuum for large database on btrfs.
Example:
(echo "pragma journal_mode=wal;" | sqlite3 db.sqlite3 .dump) | sqlite3 temp.sqlite3; mv temp.sqlite3 db.sqlite3
- aabbcc1241 4y agoAnd it may be the only option if vacuum complaints about not enough temporary disk space (it may needs close to triple storage size of the original database size, while dump and import only need double storage size)