From mboxrd@z Thu Jan 1 00:00:00 1970 From: =?UTF-8?B?QmrDtnJuIEjDtmZsaW5n?= Subject: Re: Getting a copy of the Cuirass (berlin.guixsd.org) database Date: Fri, 22 Feb 2019 17:54:05 +0100 Message-ID: <20190222175405.71c73a75@alma-ubu> References: <87y36n4w3u.fsf@cbaines.net> <20190213220006.40cd1f3a@alma-ubu> <20190221213039.68e4e88d@scratchpost.org> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; boundary="Sig_/ERd5w38Jc+6aD1BYOQAWz4a"; protocol="application/pgp-signature" Return-path: Received: from eggs.gnu.org ([209.51.188.92]:58292) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1gxE5V-0001EK-OB for guix-devel@gnu.org; Fri, 22 Feb 2019 11:54:14 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1gxE5T-0006k4-Ny for guix-devel@gnu.org; Fri, 22 Feb 2019 11:54:13 -0500 Received: from m4s11.vlinux.de ([83.151.27.109]:60874 helo=bjoernhoefling.de) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1gxE5T-0006hB-FQ for guix-devel@gnu.org; Fri, 22 Feb 2019 11:54:11 -0500 In-Reply-To: <20190221213039.68e4e88d@scratchpost.org> 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: Danny Milosavljevic Cc: guix-devel@gnu.org --Sig_/ERd5w38Jc+6aD1BYOQAWz4a Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable On Thu, 21 Feb 2019 21:30:39 +0100 Danny Milosavljevic wrote: > Hi Bj=C3=B6rn, >=20 > On Wed, 13 Feb 2019 22:00:06 +0100 > Bj=C3=B6rn H=C3=B6fling wrote: >=20 > > 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! =20 >=20 > I think we didn't set up the infrastructure to VACUUM the database. >=20 > 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=C3=B6rn --Sig_/ERd5w38Jc+6aD1BYOQAWz4a Content-Type: application/pgp-signature Content-Description: OpenPGP digital signature -----BEGIN PGP SIGNATURE----- iF0EARECAB0WIQQiGUP0np8nb5SZM4K/KGy2WT5f/QUCXHApLQAKCRC/KGy2WT5f /Q5aAJ9L+3Dsx6I/zkjLU56s0uiXmSXOMgCbBRJw1riABzlqBJpi9IxJXTZEXqE= =Rmc0 -----END PGP SIGNATURE----- --Sig_/ERd5w38Jc+6aD1BYOQAWz4a--