[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Getting a copy of the Cuirass ( database

From: Ludovic Courtès
Subject: Re: Getting a copy of the Cuirass ( database
Date: Wed, 06 Mar 2019 13:55:39 +0100
User-agent: Gnus/5.13 (Gnus v5.13) Emacs/26.1 (gnu/linux)

Hi Danny,

Danny Milosavljevic <address@hidden> skribis:

> 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.

What would it take to enable autovacuum?  Sounds like something we
should do.  :-)


reply via email to

[Prev in Thread] Current Thread [Next in Thread]