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 +9JkGHoW5V6wGAAA0tVLHw (envelope-from ) for ; Sat, 13 Jun 2020 18:10:02 +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 8KC6E3oW5V68OwAA1q6Kng (envelope-from ) for ; Sat, 13 Jun 2020 18:10:02 +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 F108C940276 for ; Sat, 13 Jun 2020 18:10:01 +0000 (UTC) Received: from localhost ([::1]:45154 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1jkAbQ-0005dl-Sw for larch@yhetil.org; Sat, 13 Jun 2020 14:10:00 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:49174) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1jkAbI-0005dW-BO for guix-devel@gnu.org; Sat, 13 Jun 2020 14:09:52 -0400 Received: from mail-wr1-x444.google.com ([2a00:1450:4864:20::444]:39953) by eggs.gnu.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1jkAbG-00082f-OZ for guix-devel@gnu.org; Sat, 13 Jun 2020 14:09:52 -0400 Received: by mail-wr1-x444.google.com with SMTP id h5so13067612wrc.7 for ; Sat, 13 Jun 2020 11:09:45 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=from:to:subject:in-reply-to:references:date:message-id:mime-version :content-transfer-encoding; bh=7oFyBBfwiEdJPCo6LHtwWhGz4qqXVdbrgd4nWUBVNh0=; b=jfIrFEY2Uofp0s5j4zorysIXJD8yPU0VPxdxZRZ+m04GVdugPSBLL7FeJGabwQxIMy t2w1czHu0ILejxay95qD9DsJAQ7Tv4I/WSOVg15TtutXkkikofGFNNhyBFsV/lJo7Rog 97TXrBJT0KmRECyKeiXwS3UJG6Gc8bYg1fsEIQnDrWZ/bMl4GySezvGsGkctJcVhiUIa MF2gFsEPIwky0uQgGkBeQEhPXzixVnMMRtsy5P8iKTrHM7g2QosrRYovOx9SE9lplvEW QWq53eatwL72iGbzr03YOO62vgtls9LneXUbUZgjyfFCmpJDLCC+S/BFS2hpXiZk+Hs5 mSnQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:to:subject:in-reply-to:references:date :message-id:mime-version:content-transfer-encoding; bh=7oFyBBfwiEdJPCo6LHtwWhGz4qqXVdbrgd4nWUBVNh0=; b=Dpaw4OTIC+sWc7t4YLZ0V44KmT468m4tkb9DYz+AHyPiKuSDzHtOgSjcUJdXPfvgmZ ChhXD48XCJXB5cFQaBu5WMrqFPFpt+RiFCXE/EtG5SteRJ4bcWiisEdm+30opNnJentr u2HqxUIGubD6HkqGrDuFN3QTf4KoePhY3M7lyIr+j1rs1w1btpheMLS0BmOZRASVYGMU fi7EDGa84zumM//GDnAqrs5xu3jC5eFEaHV5uShKjrQwGcLsiwACAqqhF4sZV1tC31Bw LKgfDJD8MSCuSYMpkWhH7d273JnI2ShkStF/3LNO0o7/b//9bV8M7vD8n4BCmvOJcpSW /fdQ== X-Gm-Message-State: AOAM533cNeXFY2llcVzzWDpZy3vW36qvd5ZRjVso8E1iU9p93iK3TC+A oQLMAgNSkU6ZqcN2/uTMoajzPYp//DQ= X-Google-Smtp-Source: ABdhPJzl4K2X8cbIaGmO+nmhow+FTCJD0MuSiius8GHP57Az7cqtor+xQhaE+aYtgmwioC7cewg4gw== X-Received: by 2002:a5d:54c3:: with SMTP id x3mr20257032wrv.312.1592071783565; Sat, 13 Jun 2020 11:09:43 -0700 (PDT) Received: from lili (57.246.195.77.rev.sfr.net. [77.195.246.57]) by smtp.gmail.com with ESMTPSA id n1sm15642439wrp.10.2020.06.13.11.09.42 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sat, 13 Jun 2020 11:09:42 -0700 (PDT) From: zimoun To: Christopher Baines , guix-devel@gnu.org Subject: Re: [PATCH] sql: Add a couple of indexes. In-Reply-To: <87mu577wv5.fsf@cbaines.net> References: <20200609205342.613-1-mail@cbaines.net> <87mu577wv5.fsf@cbaines.net> Date: Sat, 13 Jun 2020 20:09:40 +0200 Message-ID: <867dwaalcr.fsf@gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Received-SPF: pass client-ip=2a00:1450:4864:20::444; envelope-from=zimon.toutoune@gmail.com; helo=mail-wr1-x444.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: , 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=jfIrFEY2; 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: 2O6SUC8wu2o6 Hi Chris, On Sat, 13 Jun 2020 at 17:29, Christopher Baines wrote: > I've pushed a rebased version of this patch now. I've also recofigured > bayfront to apply these changes. Checking with guix weather, I think it > might be helping. Nice! What about reconfigure ci.guix.gnu.org and close bug#41708? http://issues.guix.gnu.org/issue/41708 > =E2=86=92 guix weather --substitute-urls=3Dhttps://bayfront.guix.gnu.org [...] > 13.8% (897 out of 6,519) of the missing items are queued > at least 1,000 queued builds > x86_64-linux: 1000 (100.0%) > build rate: 9.34 builds per hour > x86_64-linux: 9.34 builds per hour I think it is the first I see these results instead of the 504. :-) With "guix e782756", it is: --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? All the best, simon