[GRASS-dev] [GRASS GIS] #3697: sqlite db: automatically enable vacuum

GRASS GIS trac at osgeo.org
Tue Nov 20 02:16:08 PST 2018


#3697: sqlite db: automatically enable vacuum
---------------------------+-------------------------
 Reporter:  mlennert       |      Owner:  grass-dev@…
     Type:  enhancement    |     Status:  new
 Priority:  normal         |  Milestone:  7.8.0
Component:  Database       |    Version:  unspecified
 Keywords:  sqlite vacuum  |        CPU:  Unspecified
 Platform:  Unspecified    |
---------------------------+-------------------------
 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.

-- 
Ticket URL: <https://trac.osgeo.org/grass/ticket/3697>
GRASS GIS <https://grass.osgeo.org>



More information about the grass-dev mailing list