From mboxrd@z Thu Jan 1 00:00:00 1970 From: Christopher Baines Subject: Re: Getting a copy of the Cuirass (berlin.guixsd.org) database Date: Wed, 06 Mar 2019 19:08:43 +0000 Message-ID: <877edbg6ro.fsf@cbaines.net> References: <87y36n4w3u.fsf@cbaines.net> <20190213220006.40cd1f3a@alma-ubu> <20190221213039.68e4e88d@scratchpost.org> <87fts0jh6c.fsf@gnu.org> Mime-Version: 1.0 Content-Type: multipart/signed; boundary="=-=-="; micalg=pgp-sha512; protocol="application/pgp-signature" Return-path: Received: from eggs.gnu.org ([209.51.188.92]:43235) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1h1buQ-0004iu-BD for guix-devel@gnu.org; Wed, 06 Mar 2019 14:08:55 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1h1buO-0007Lq-Em for guix-devel@gnu.org; Wed, 06 Mar 2019 14:08:54 -0500 In-reply-to: <87fts0jh6c.fsf@gnu.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: Ludovic =?utf-8?Q?Court=C3=A8s?= Cc: guix-devel@gnu.org --=-=-= Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Ludovic Court=C3=A8s writes: > Hi Danny, > > Danny Milosavljevic skribis: > >> 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. > > What would it take to enable autovacuum? Sounds like something we > should do. :-) I think vacuum can result in the rowid values changing [1], and in at least one place (the build ids), the rowid values are exposed to users. 1: https://www.sqlite.org/lang_createtable.html#rowid I think by creating a explicit column for the id, it's possible to avoid them changing during the vacuum, so it might be good to do that before vacuuming. --=-=-= Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQKTBAEBCgB9FiEEPonu50WOcg2XVOCyXiijOwuE9XcFAlyAGrxfFIAAAAAALgAo aXNzdWVyLWZwckBub3RhdGlvbnMub3BlbnBncC5maWZ0aGhvcnNlbWFuLm5ldDNF ODlFRUU3NDU4RTcyMEQ5NzU0RTBCMjVFMjhBMzNCMEI4NEY1NzcACgkQXiijOwuE 9XcScw/9GLhHYcG4I0/IxzW1sBFkNU653nIQM52hCoxei/W5pMoI1UDezzcxguno FVvfy0wQngo2dBBih0dj7F+2L4U91iYndobpyohVd6CbUVXe9yiDsrWLSrpB9TYc QD/ISRrbj/36mE8vZCYeRO9rG4AayshyJU1pVzo2zE/+l3kHJEi0u+kPlkVGWxzI 6gLi6qaUFzgC2C3e59tmMARXzEJr5KAVBc5d7v7g1JYvJ82GDmBKT1A8Byv73Jmi Pc4wyizbYH0n2mHkSe8fj6s8mw35RxEdJbDV8twsVmDkbQ+ZZJ201V48qMZ/7q/6 Cm1/ErQairh57BlOXQG5s+nA3hj12EgqCsDZtC136uoIXr0D78Shwcb14ZkOaFsE 6MaaNKx1cXsSMZftJVW9pnotpJ1fAMzMyJktKQtn+Pqg/LAZIuZMpER/U3i4nNZy wbm7MA2u2QkqB1dSlMdXOdBNBBysAy+04rNEL10y+TA/HEnef0gIJB8KDGfcKpSf ewyjyQNEMRuAvk5QeAS9XBD8Fp4Xg574VMtLRhvH6MujEm9A1m9QQ4xpYTF4aGE0 P7bRTP1sSGMFvgVjSYDOaXVGm8DDpibRvuQAr8BzsAlgbwUQOSM5c5dORIjKUIk5 8rLZD6Zu2cEdap2PG1S4mG2q7xtNutNB0EK11Cx3mgYtUG/elt8= =5arQ -----END PGP SIGNATURE----- --=-=-=--