Re: Getting a copy of the Cuirass (berlin.guixsd.org) database

[Danny Milosavljevic]

Hi Björn,

On Wed, 13 Feb 2019 22:00:06 +0100
Björn Höfling <address@hidden> wrote:

> I'm not sure if anybody else responded to you, but I have a database
> around. I got it last year from Clement Lassieur. It is 1.6 GB in size,
> I made a tar.xz an that is only 86 MB! I wonder if there is anything
> wrong or it is just thaaat compressible!

I think we didn't set up the infrastructure to VACUUM the database.

The default in sqlite is not to VACUUM ever, so we probably should
either stop the entire thing and vacuum it once a week or we could
set up autovacuum to incremental or full (the latter would vacuum
at each commit) if we ever ran out of space.

pgpcjSz0zaRuK.pgp
Description: OpenPGP digital signature