"Note, however, that auto-vacuum only truncates the freelist pages
from the file. Auto-vacuum does not defragment the database nor repack
individual database pages the way that the VACUUM command does. In
fact, because it moves pages around within the file, auto-vacuum can
actually make fragmentation worse."
We might want to consider the above before making auto_vacuum the
default.
Even without auto_vacuum, the database does eventually reclaim free
space by reusing it for subsequent inserts. So, perhaps auto_vacuum is
not so important unless you're regularly deleting large amounts of
data and not replacing it very quickly (otherwise, a periodic VACUUM
might be adequate).
Anthony
On Sep 29, 9:43 am, mdipierro <mdipie...@cs.depaul.edu> wrote:
> should this be default?
>
> On Sep 29, 5:56 am, rochacbruno <rochacbr...@gmail.com> wrote:
>
>
>
> > db.executesql('PRAGMA auto_vacuum = X') ?
>
> > Enviado via iPhone
>
> > Em 29/09/2010, às 06:01, winti <stefan.winterb...@gmail.com> escreveu:
>
> > > Hello,
> > > is there a way to reclaim free space in sqlite db's within web2py as
> > > described here:
>
> > >http://www.sqlite.org/pragma.html#pragma_auto_vacuum
>
> > > Stefan- Hide quoted text -
>
> - Show quoted text -
