Thanks Even!
The VACUUM command worked and indeed the file is now much smaller.
Thank you for adding this information to the Geopackage documentation!
I wasn't aware that I could run any SQL command through ogrinfo. Nice!
Greetings,
Andreas
Am 30.11.2016 um 21:24 schrieb Even Rouault:
On mercredi 30 novembre 2016 21:11:14 CET Andreas Neumann wrote:
> Hi Even,
>
> Thanks. I will use the 'ogrinfo your.gpkg -sql "DROP TABLE table_name"'
> trick for now.
>
> One thing though: I noticed that the filesize doesn't really shrink. Is
> there a way to compact/vacuum the geopackage after removal of the table?
You actually mentionned the appropriate SQL command: VACUUM :-)
I've just added this new paragraph to http://gdal.org/drv_geopackage.html:
"""When dropping a table, or removing records from tables, the space they
occupied is not immediately released and kept in the pool of file
pages that
SQLite may reuse later. If you need to shrink the file to its minimum
size,
you need to issue an explicit "VACUUM" SQL request. Note that this will
result in a full rewrite of the file."""
Even
--
Spatialys - Geospatial professional services
http://www.spatialys.com
_______________________________________________
gdal-dev mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/gdal-dev
