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 kHW1EpMYgF+kMwAA0tVLHw (envelope-from ) for ; Fri, 09 Oct 2020 08:00:19 +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 CC6sDpMYgF8KKQAA1q6Kng (envelope-from ) for ; Fri, 09 Oct 2020 08:00:19 +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 79CE4940539 for ; Fri, 9 Oct 2020 08:00:17 +0000 (UTC) Received: from localhost ([::1]:48384 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1kQnK1-000857-QB for larch@yhetil.org; Fri, 09 Oct 2020 04:00:14 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:40932) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kQnJq-00084S-MJ for bug-guix@gnu.org; Fri, 09 Oct 2020 04:00:02 -0400 Received: from debbugs.gnu.org ([209.51.188.43]:50720) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1kQnJq-00019s-Bi for bug-guix@gnu.org; Fri, 09 Oct 2020 04:00:02 -0400 Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1kQnJq-0002L1-91 for bug-guix@gnu.org; Fri, 09 Oct 2020 04:00:02 -0400 X-Loop: help-debbugs@gnu.org Subject: bug#43564: cuirass: Contention while registering new builds. Resent-From: Ludovic =?UTF-8?Q?Court=C3=A8s?= Original-Sender: "Debbugs-submit" Resent-CC: bug-guix@gnu.org Resent-Date: Fri, 09 Oct 2020 08:00:02 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 43564 X-GNU-PR-Package: guix X-GNU-PR-Keywords: To: Mathieu Othacehe Received: via spool by 43564-submit@debbugs.gnu.org id=B43564.16022303838933 (code B ref 43564); Fri, 09 Oct 2020 08:00:02 +0000 Received: (at 43564) by debbugs.gnu.org; 9 Oct 2020 07:59:43 +0000 Received: from localhost ([127.0.0.1]:34033 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1kQnJW-0002K0-Ui for submit@debbugs.gnu.org; Fri, 09 Oct 2020 03:59:43 -0400 Received: from eggs.gnu.org ([209.51.188.92]:34084) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1kQnJU-0002Jn-AQ for 43564@debbugs.gnu.org; Fri, 09 Oct 2020 03:59:41 -0400 Received: from fencepost.gnu.org ([2001:470:142:3::e]:55127) by eggs.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1kQnJP-00016W-0R for 43564@debbugs.gnu.org; Fri, 09 Oct 2020 03:59:35 -0400 Received: from [2a01:e0a:1d:7270:af76:b9b:ca24:c465] (port=55782 helo=ribbon) by fencepost.gnu.org with esmtpsa (TLS1.2:RSA_AES_256_CBC_SHA1:256) (Exim 4.82) (envelope-from ) id 1kQnJO-0002Wn-AR; Fri, 09 Oct 2020 03:59:34 -0400 From: Ludovic =?UTF-8?Q?Court=C3=A8s?= References: <87imc5zrc8.fsf@gnu.org> <87k0wee3ud.fsf@gnu.org> <87v9fo27vz.fsf@gnu.org> <87k0w47rbh.fsf@gnu.org> X-URL: http://www.fdn.fr/~lcourtes/ X-Revolutionary-Date: 18 =?UTF-8?Q?Vend=C3=A9miaire?= an 229 de la =?UTF-8?Q?R=C3=A9volution?= X-PGP-Key-ID: 0x090B11993D9AEBB5 X-PGP-Key: http://www.fdn.fr/~lcourtes/ludovic.asc X-PGP-Fingerprint: 3CE4 6455 8A84 FDC6 9DB4 0CFB 090B 1199 3D9A EBB5 X-OS: x86_64-pc-linux-gnu Date: Fri, 09 Oct 2020 09:59:31 +0200 In-Reply-To: <87k0w47rbh.fsf@gnu.org> (Mathieu Othacehe's message of "Mon, 05 Oct 2020 15:09:06 +0200") Message-ID: <87y2kfomn0.fsf@gnu.org> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/27.1 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-Spam-Score: -2.3 (--) X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list X-Spam-Score: -3.3 (---) X-BeenThere: bug-guix@gnu.org List-Id: Bug reports for GNU Guix List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Cc: 43564@debbugs.gnu.org Errors-To: bug-guix-bounces+larch=yhetil.org@gnu.org Sender: "bug-Guix" X-Scanner: scn0 Authentication-Results: aspmx1.migadu.com; dkim=none; dmarc=pass (policy=none) header.from=gnu.org; spf=pass (aspmx1.migadu.com: domain of bug-guix-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=bug-guix-bounces@gnu.org X-Spam-Score: -1.51 X-TUID: 1qVxc2Mx4gYs Hi, Mathieu Othacehe skribis: >> Isn=E2=80=99t that the real problem, that we=E2=80=99re doing one transa= ction per >> derivation? > > Is it really better in term of performance to send batch of queries > within a single transaction? I haven't tried it yet. I=E2=80=99m definitely not a database expert, but I think there=E2=80=99s o= verhead for setting up a transaction, which we=E2=80=99re paying N times here. > I think that the real bottleneck was having N fibers fighting over 4 > workers to execute large number of insertions. Having all those queries > done by workers dedicated to registration in a single pass seems to > improve a lot the situation. Then that=E2=80=99s great, let=E2=80=99s profit! :-) Ludo=E2=80=99.