From mboxrd@z Thu Jan  1 00:00:00 1970
From: =?utf-8?Q?Ludovic_Court=C3=A8s?= <ludo@gnu.org>
Subject: Re: Getting a copy of the Cuirass (berlin.guixsd.org) database
Date: Wed, 06 Mar 2019 13:55:39 +0100
Message-ID: <87fts0jh6c.fsf@gnu.org>
References: <87y36n4w3u.fsf@cbaines.net> <20190213220006.40cd1f3a@alma-ubu>
	<20190221213039.68e4e88d@scratchpost.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Return-path: <guix-devel-bounces+gcggd-guix-devel=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([209.51.188.92]:56146)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <ludo@gnu.org>) id 1h1W5J-0006vP-OW
	for guix-devel@gnu.org; Wed, 06 Mar 2019 07:55:46 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <ludo@gnu.org>) id 1h1W5J-0006Nm-1F
	for guix-devel@gnu.org; Wed, 06 Mar 2019 07:55:45 -0500
Received: from hera.aquilenet.fr ([2a0c:e300::1]:40590)
	by eggs.gnu.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32)
	(Exim 4.71) (envelope-from <ludo@gnu.org>) id 1h1W5I-0006MG-QX
	for guix-devel@gnu.org; Wed, 06 Mar 2019 07:55:44 -0500
In-Reply-To: <20190221213039.68e4e88d@scratchpost.org> (Danny Milosavljevic's
	message of "Thu, 21 Feb 2019 21:30:39 +0100")
List-Id: "Development of GNU Guix and the GNU System distribution."
	<guix-devel.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/guix-devel>,
	<mailto:guix-devel-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/guix-devel/>
List-Post: <mailto:guix-devel@gnu.org>
List-Help: <mailto:guix-devel-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/guix-devel>,
	<mailto:guix-devel-request@gnu.org?subject=subscribe>
Errors-To: guix-devel-bounces+gcggd-guix-devel=m.gmane.org@gnu.org
Sender: "Guix-devel" <guix-devel-bounces+gcggd-guix-devel=m.gmane.org@gnu.org>
To: Danny Milosavljevic <dannym@scratchpost.org>
Cc: guix-devel@gnu.org

Hi Danny,

Danny Milosavljevic <dannym@scratchpost.org> skribis:

> On Wed, 13 Feb 2019 22:00:06 +0100
> Bj=C3=B6rn H=C3=B6fling <bjoern.hoefling@bjoernhoefling.de> 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.  :-)

Ludo=E2=80=99.