On Sat, Sep 18, 2010 at 2:36 PM, Kyle McKay <mack...@gmail.com> wrote:
> On Sep 17, 2010, at 16:08:42 PDT, Oliver Schneider wrote: > > just a few minutes ago I ran a VACUUM on a DB file and the size before > > was 2089610240 and afterwards 2135066624. Is this normal? > > I've recently been noticing the same thing, for example: > > 443182080 newdb.sq3 > $ sqlite3 newdb.sq3 > SQLite version 3.6.22 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> PRAGMA freelist_count; > 0 > sqlite> PRAGMA integrity_check; > ok > sqlite> vacuum; > sqlite> PRAGMA freelist_count; > 0 > sqlite> PRAGMA integrity_check; > ok > sqlite> .quit > 444920832 newdb.sq3 > > Admittedly that's only about 0.4% growth in size, but I too was under > the impression that vacuum did not grow the database size. Subsequent > vacuum commands do not seem to grow the database any further. > Can you please run sqlite3_analyzer (available from http://www.sqlite.org/download.html) on both the original database and the database after VACUUM and send me the output? > > Kyle > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
