Comment 84 for bug 215728

I have to agree with Rick Stockton. It would be a mistake to characterize this bug as some kind of ramp-up cost for new users only. I use Firefox continuously on my laptop and I also see this bug pretty much all day long. You can see from my strace that Firefox had written more than 30MB within a few minutes of starting, and I can reproduce that behavior at will.

From my very little experience with sqlite, my impression of this bug is that either we're doing full database writes when we think we're doing incremental updates, or we're doing full database vacuums when we wanted incremental vacuum.

Aside from that, what stands out to me in the strace log is that it looks like the sqlite database is initialized with 1KiB pages. It might be a lot more efficient if it used the same page size as my filesystem (4KiB). This could be queried before initializing the database, or if that's too complicated then 4KiB is a far better default on modern Linux systems anyway.