From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp0 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id wJv1DchD516WLgAA0tVLHw (envelope-from ) for ; Mon, 15 Jun 2020 09:47:52 +0000 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp0 with LMTPS id KFjQCchD515zHQAA1q6Kng (envelope-from ) for ; Mon, 15 Jun 2020 09:47:52 +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 A44C1940900 for ; Mon, 15 Jun 2020 09:47:51 +0000 (UTC) Received: from localhost ([::1]:32918 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1jkliY-0002OR-Kb for larch@yhetil.org; Mon, 15 Jun 2020 05:47:50 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:40666) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1jklg5-0000Dm-VQ for guix-devel@gnu.org; Mon, 15 Jun 2020 05:45:18 -0400 Received: from mail-wr1-x441.google.com ([2a00:1450:4864:20::441]:46654) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1jklg0-0006Ua-Go for guix-devel@gnu.org; Mon, 15 Jun 2020 05:45:17 -0400 Received: by mail-wr1-x441.google.com with SMTP id x6so16342237wrm.13 for ; Mon, 15 Jun 2020 02:45:12 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=from:to:cc:subject:in-reply-to:references:date:message-id :mime-version; bh=QpWGu5C67O3VpzcAPqNIDLLuKYC9rzIWO6xL4P5LGJ4=; b=WACONwGUZgWUiJjUTKkAXjXKf52FVxfedd1DZhoLWigMTp4BaHJ5KisQfzPpApSdog 7NU6Y1RuI/4nMKciU8T7CG+H1w3uIlEEwV4hCEslGxzXdImVWQn6ycQcpgL28kFM3ynt cF4w80SKI3NOarsFUXfPGFsYatJoUSG46wXcihF4nO0LCBMkSQZA11Cl3k/LdQGnaPAD MK6yfZTOLzSoHa1zEAt3ccaqiG8CCtElTqSf32X8Yx0jHW5tYP15xCYloCQSfe4a5ccs KM3zT9iI7zUfUC4qh9aXrBXIrcONFsbBa+vH7qnaUvKwBMBuO3/VPTjhut3AI1DcKAtc LM9A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:to:cc:subject:in-reply-to:references:date :message-id:mime-version; bh=QpWGu5C67O3VpzcAPqNIDLLuKYC9rzIWO6xL4P5LGJ4=; b=ZzkmuP/ImMIyQhaFYfMJdYlz3qRB2JVKDzIUX8VEe4Phiz1hz9PfibKn10Otp3DgPL QkZapTYN+98RakU13JXRp0bb6DZyF5Nv4wFBmUX7B8yps1tLqd72YKKY4pAtbbSOpcmG lLKU7ATHC3ua7pOcNrIMi/Zaqmy4LjPPIZusg2onUXV6kcOZpBp3DG3LbiGMZR1Agppn ImomsBUnanuFQ84rX3183tW4J3LS5IRsGoeOySxYYNDzDxmcu3sG4D0rgZh//M7vqZDg LSeGpu3U9NZLs0E2c3RjHVT+RZbcEUEuJ8w32bWwahSEp6Buk51OLzScN1mSV13l017d PdfA== X-Gm-Message-State: AOAM533MBm38OAK7fRX/pDqIB6lD3r5iKDKtvrHnsFeiNqJteupiTgDW AXuHWMxYD/CYGvwRL+EQZ9oXNzVynak= X-Google-Smtp-Source: ABdhPJwf1DQ1Nc7gXbMDw+v824KmRCS/tXiNKEf4GVpWN7kKzUZlANdQJKcUzGqjJY/XQmnq+L5bQQ== X-Received: by 2002:adf:ec0a:: with SMTP id x10mr27563276wrn.130.1592214310366; Mon, 15 Jun 2020 02:45:10 -0700 (PDT) Received: from lili (57.246.195.77.rev.sfr.net. [77.195.246.57]) by smtp.gmail.com with ESMTPSA id q13sm23911817wrn.84.2020.06.15.02.45.08 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 15 Jun 2020 02:45:09 -0700 (PDT) From: zimoun To: Christopher Baines Subject: Re: [PATCH] sql: Add a couple of indexes. In-Reply-To: <87imft98cq.fsf@cbaines.net> References: <20200609205342.613-1-mail@cbaines.net> <87mu577wv5.fsf@cbaines.net> <867dwaalcr.fsf@gmail.com> <87imft98cq.fsf@cbaines.net> Date: Mon, 15 Jun 2020 11:45:03 +0200 Message-ID: <86imfs8xy8.fsf@gmail.com> MIME-Version: 1.0 Content-Type: text/plain Received-SPF: pass client-ip=2a00:1450:4864:20::441; envelope-from=zimon.toutoune@gmail.com; helo=mail-wr1-x441.google.com X-detected-operating-system: by eggs.gnu.org: No matching host in p0f cache. That's all we know. X-Spam_score_int: -20 X-Spam_score: -2.1 X-Spam_bar: -- X-Spam_report: (-2.1 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_NONE=0.001, SPF_PASS=-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=pass header.d=gmail.com header.s=20161025 header.b=WACONwGU; dmarc=pass (policy=none) header.from=gmail.com; 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: -1.71 X-TUID: ca6j/89DFMZU 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. I agree that these 1/3 non-available substitutes can be because only one essential package fails. We discussed at Guix Days something like "guix weather --release"; which could help to report what maintainers/developers consider as essential. However, I feel that something is lacking to identify which package is failing and what is its impact. Something like: the build fails then a warning is raised if "guix refresh -l" is too high. Cheers, simon