On Sep 9, 2008, at 10:10 PM, Ribeiro, Glauber wrote: > Hello, > > Here's another newbie question, but it doesn't look like the > documentation for vacuum covers this. > > I'm using SQLite to store an application's log. Suppose I have a > program > that runs nightly and deletes log records that are older than 60 days, > to keep the database from growing without boundaries. > > I understand that deleting the records doesn't shrink the database > file, > unless I also vacuum. However, will SQLite re-use the space taken > by the > deleted records to store new ones? (Would I be better off not doing > vacuum, and letting SQLite reuse the disk space instead?) I believe > this > is the case with PostgreSQL.
It will reuse the freed space. Dan. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
