From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp1 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id 8P8lA+q6514hOgAA0tVLHw (envelope-from ) for ; Mon, 15 Jun 2020 18:16:10 +0000 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp1 with LMTPS id 2L+HOum6514GOwAAbx9fmQ (envelope-from ) for ; Mon, 15 Jun 2020 18:16:09 +0000 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id 7614B9404D4 for ; Mon, 15 Jun 2020 18:16:09 +0000 (UTC) Received: from localhost ([::1]:44386 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1jkteS-0003br-63 for larch@yhetil.org; Mon, 15 Jun 2020 14:16:08 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:60498) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1jkteE-0003be-QF for guix-devel@gnu.org; Mon, 15 Jun 2020 14:15:54 -0400 Received: from mira.cbaines.net ([2a01:7e00:e000:2f8:fd4d:b5c7:13fb:3d27]:44725) by eggs.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1jkteD-0001lU-3e for guix-devel@gnu.org; Mon, 15 Jun 2020 14:15:54 -0400 Received: from localhost (unknown [46.237.174.223]) by mira.cbaines.net (Postfix) with ESMTPSA id EDD0A27BBE1; Mon, 15 Jun 2020 19:15:50 +0100 (BST) Received: from localhost (localhost [local]) by localhost (OpenSMTPD) with ESMTPA id 0368ed20; Mon, 15 Jun 2020 18:15:48 +0000 (UTC) References: <20200609205342.613-1-mail@cbaines.net> <87mu577wv5.fsf@cbaines.net> <867dwaalcr.fsf@gmail.com> <87imft98cq.fsf@cbaines.net> <86imfs8xy8.fsf@gmail.com> User-agent: mu4e 1.2.0; emacs 26.3 From: Christopher Baines To: zimoun Subject: Re: [PATCH] sql: Add a couple of indexes. Date: Mon, 15 Jun 2020 19:12:07 +0100 Message-ID: <875zbsb3m0.fsf@cbaines.net> In-reply-to: <86imfs8xy8.fsf@gmail.com> MIME-Version: 1.0 Content-Type: multipart/signed; boundary="=-=-="; micalg=pgp-sha512; protocol="application/pgp-signature" Received-SPF: pass client-ip=2a01:7e00:e000:2f8:fd4d:b5c7:13fb:3d27; envelope-from=mail@cbaines.net; helo=mira.cbaines.net X-detected-operating-system: by eggs.gnu.org: First seen = 2020/06/15 14:15:51 X-ACL-Warn: Detected OS = ??? X-Spam_score_int: -18 X-Spam_score: -1.9 X-Spam_bar: - X-Spam_report: (-1.9 / 5.0 requ) BAYES_00=-1.9, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001, UNPARSEABLE_RELAY=0.001 autolearn=_AUTOLEARN X-Spam_action: no action X-BeenThere: guix-devel@gnu.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: "Development of GNU Guix and the GNU System distribution." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Cc: guix-devel@gnu.org Errors-To: guix-devel-bounces+larch=yhetil.org@gnu.org Sender: "Guix-devel" X-Scanner: scn0 Authentication-Results: aspmx1.migadu.com; dkim=none; dmarc=none; spf=pass (aspmx1.migadu.com: domain of guix-devel-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=guix-devel-bounces@gnu.org X-Spam-Score: -0.61 X-TUID: CnT34fHR5LlZ --=-=-= Content-Type: text/plain Content-Transfer-Encoding: quoted-printable zimoun writes: > Hi Chris, > > On Sun, 14 Jun 2020 at 12:48, Christopher Baines wrote: > >>> --8<---------------cut here---------------start------------->8--- >>> 65.7% substitutes available (9,425 out of 14,354) >>> at least 57,816.3 MiB of nars (compressed) >>> 97,343.9 MiB on disk (uncompressed) >>> 0.010 seconds per request (138.1 seconds in total) >>> 103.0 requests per second >>> >>> 0.0% (0 out of 4,929) of the missing items are queued >>> at least 1,000 queued builds >>> x86_64-linux: 1000 (100.0%) >>> build rate: 9.20 builds per hour >>> x86_64-linux: 9.20 builds per hour >>> --8<---------------cut here---------------end--------------->8--- >>> >>> Hum? Almost 1/3 of substitutes are not available and in the same time >>> not queued. Is it expected? Does it mean that 1/3 of the builds are >>> failing? >> >> Probably not, most likely canceled or a dependency failed to build. > > Well, it depends on how you define what is a build. ;-) Because if one > package's dependency does not build, the package cannot build either. Yeah. Given this is about Cuirass, I was sort of using the Cuirass build states, which does distinguish a build that was attempted, and failed, from one which couldn't be attempted because an input was lacking. --=-=-= Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQKTBAEBCgB9FiEEPonu50WOcg2XVOCyXiijOwuE9XcFAl7nutNfFIAAAAAALgAo aXNzdWVyLWZwckBub3RhdGlvbnMub3BlbnBncC5maWZ0aGhvcnNlbWFuLm5ldDNF ODlFRUU3NDU4RTcyMEQ5NzU0RTBCMjVFMjhBMzNCMEI4NEY1NzcACgkQXiijOwuE 9Xc+yQ/+OJDXNMfST2BTJGXcYx/hWxSXMhZA+GOtuRhwgPbUoQdzGxAIwehc6dgT rk+/SywqTKeQo4vHcEp/I9CM/kKp8W54eqZ/udAmnvqlC2ADAmLDzOZyyqsuHdNB coH7Fb9cz730Ba6U/QNNznVaXhGx29g9ZlfoiLTCzAivPnNX9Er5OKiorqAjoBUp BOj2GumhLOPC6jrgjwOeYVQ2kqpct4qL9hbA9MS6EUP14/rW70fJxiGE4r9i6jiC WuGIEjmZtDDWr32PmmjWnhdH3mjiPuVsOFTekwjt85DVl/ZVU7IoUVAXFOy75caH y4RIVLBwwYyUvxCY0hJT/34wkW60tllmFU2NgZr0vIdF1GVqyYBF3kX/tugf7ck8 ZpH52cyFkYBWYOhIyKpVntekec2YFGuTO23rn8fWP/0ALKiSP5aVVRx0xSubdkMy lewYs3cUtnSMlNLSxUEYb4Ufi1Oh2SD+VUmojpsShQsjduxgL3m7O0T8Q1mEmVV1 v5sYPEFf+zzIFDDr5NK+hCubQibN4XZnjbW7OZdWBI9V7sQJwJTsD4ot2bFVJ1Tm 4MA7p6EpG7tS7uqm5ctx/IKNIsikBmNMdF1SXH1OXb6SNuCyD2hwlFRPl6wr018q vuNXd91lN8fT4jERqP2gIRmAzu7OJ5mx9earojOBcdvZ8mk5W7g= =9B0W -----END PGP SIGNATURE----- --=-=-=--