2012/2/8 Lluís Batlle i Rossell <[email protected]>
> On Wed, Feb 08, 2012 at 10:16:24AM -0500, Leo Razoumov wrote:
> > > The _FOSSIL_ file contains (among other things) your stash and your
> undo
> > > history. What does
> > >
> > > sqlite3_analyzer _FOSSIL_
> > >
> > > show you? Which tables are using the most space. Maybe it just needs
> to be
> > > vacuumed?
>
> Looks to me like just needing a vacuum (most pages are free pages).
> "sqlite3
> _FOSSIL_ vacuum".
>
Probably what happened is that you did some operation that created a large
"undo" stack, which was stored in the _FOSSIL_ file. Then later, after the
undo expired, that space was freed. If the space utilization is an issue
for you, you can do this:
sqlite3 _FOSSIL_ 'PRAGMA auto_vacuum=FULL; VACUUM;'
And then the space will be automatically reclaimed in the future.
I generally don't stress over a 10MB file on my 1TB disk drive, though...
> _______________________________________________
> fossil-users mailing list
> [email protected]
> http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
>
--
D. Richard Hipp
[email protected]
_______________________________________________
fossil-users mailing list
[email protected]
http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
