id summary reporter owner description type status priority milestone component version resolution keywords cc cpu platform 3697 sqlite db: automatically enable vacuum mlennert grass-dev@… "I just noticed that a mapset sqlite db file was huge, despite the fact that there was only one small vector file left in it. Running 'vacuum;' in the sqlite database reduced the announced file size from 47G to 78K ! There is a pragma auto_vacuum which allows to enable an auto-vacuum mode, which is not as efficient as calling the vacuum command, as it does not defragment the database, but I would think that it would at least keep file size to expected levels. I would, therefore, plead for enabling this pragma by default at database creation and setting it to 1 (full). I think this would be the behavior expected by most users." enhancement closed normal 7.6.2 Database svn-releasebranch76 fixed sqlite vacuum Unspecified Unspecified