From mboxrd@z Thu Jan 1 00:00:00 1970 From: Danny Milosavljevic Subject: Re: Getting a copy of the Cuirass (berlin.guixsd.org) database Date: Thu, 21 Feb 2019 21:30:39 +0100 Message-ID: <20190221213039.68e4e88d@scratchpost.org> References: <87y36n4w3u.fsf@cbaines.net> <20190213220006.40cd1f3a@alma-ubu> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha256; boundary="Sig_/CdDp9DpduH=wspG=2t+tR9h"; protocol="application/pgp-signature" Return-path: Received: from eggs.gnu.org ([209.51.188.92]:49043) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1gwuzr-0005EK-2G for guix-devel@gnu.org; Thu, 21 Feb 2019 15:31:08 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1gwuzq-00009e-7t for guix-devel@gnu.org; Thu, 21 Feb 2019 15:31:07 -0500 Received: from dd26836.kasserver.com ([85.13.145.193]:37280) by eggs.gnu.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.71) (envelope-from ) id 1gwuzp-0008N8-UR for guix-devel@gnu.org; Thu, 21 Feb 2019 15:31:06 -0500 In-Reply-To: <20190213220006.40cd1f3a@alma-ubu> List-Id: "Development of GNU Guix and the GNU System distribution." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: guix-devel-bounces+gcggd-guix-devel=m.gmane.org@gnu.org Sender: "Guix-devel" To: =?ISO-8859-1?Q?Bj=F6rn_H=F6fling?= Cc: guix-devel@gnu.org --Sig_/CdDp9DpduH=wspG=2t+tR9h Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi Bj=C3=B6rn, On Wed, 13 Feb 2019 22:00:06 +0100 Bj=C3=B6rn H=C3=B6fling 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. --Sig_/CdDp9DpduH=wspG=2t+tR9h Content-Type: application/pgp-signature Content-Description: OpenPGP digital signature -----BEGIN PGP SIGNATURE----- iQEzBAEBCAAdFiEEds7GsXJ0tGXALbPZ5xo1VCwwuqUFAlxvCm8ACgkQ5xo1VCww uqVMzwf8DMkb/JqIrKAm57ZVQBnM2byZ53sEdSyrWlQecIbrbczZfahj7/MXedC7 TgidWk3ak5NHsUAbfciluW0GL21Fv/IS3aRlXHYY6MbKrDgEZ7EhvasyKT8unwtM oZo9LrKwLksu5hEj4BiK2pTc9sVtqX3OV1FRVWT7HKkVvNIm9Cc97qxL1DnM4dpG lKpxCvtLCNywXjbGY0FuuZg1uk3QKTzq3845cbRASeiCszcU4y8lPGChqhSG3ZFo EBYX+4kigU3T44J5w25UOTQLMrRxrkWLevbVvtMwzZYtIsbZJjIEXpLFkFxaN8hu k/UdE7+hArm+ZlHERcT9NQGOTgo4iw== =DwSB -----END PGP SIGNATURE----- --Sig_/CdDp9DpduH=wspG=2t+tR9h--