[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Getting a copy of the Cuirass (berlin.guixsd.org) database
From: |
Björn Höfling |
Subject: |
Re: Getting a copy of the Cuirass (berlin.guixsd.org) database |
Date: |
Fri, 22 Feb 2019 17:54:05 +0100 |
On Thu, 21 Feb 2019 21:30:39 +0100
Danny Milosavljevic <address@hidden> wrote:
> 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.
That would at least tell why it is so good compressable.
Björn
pgpjorOmtSeQz.pgp
Description: OpenPGP digital signature