Hacker News Reader

Comment by nodata | Hacker News Reader

To defrag your databases, first close Firefox then run:

  for i in ~/.mozilla/firefox/*default/*ite; do sqlite3 $i vacuum; done

View on HN

Note that this does not defragment the storage on disk, just the internal SQLite pages. So it's not a complete solution.

Actually, that command will also rewrite the entire .sqlite file, and if you have enough free space, the filesystem will most likely rewrite it in a contiguous manner.

I tested this with filefrag.

Reply on news.ycombinator.com