On Mon, Jan 4, 2016 at 12:28 PM, Simon Slavin <slavins at bigfraud.org> wrote: > > That's 3 hours 23 minutes. For a 38 Gigabyte database including a table with > half a billion rows. > > Details: Running in the SQLite 3.8.5 shell tool on a four year old iMac with > a spinning rust storage system. VACUUM was running in the background while I > was doing light work (editing web pages, a bit of email, etc.) in the > foreground. > > So you can criticise how VACUUM works if you like, but on a cheap old iMac, > working in the background, it can still get through a big database in just a > few hours. > > Simon.
You wouldn't have monitored disk usage of that, would you? I am curious about how faster a good SSD would make it as it clearly doesn't look like a CPU or memory bound operation. -- Bernardo Sulzbach