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 +FhbNcmxDV+XAgAA0tVLHw (envelope-from ) for ; Tue, 14 Jul 2020 13:23:21 +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 oPoVMcmxDV9bTQAAbx9fmQ (envelope-from ) for ; Tue, 14 Jul 2020 13:23:21 +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 685669404CB for ; Tue, 14 Jul 2020 13:23:21 +0000 (UTC) Received: from localhost ([::1]:43270 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1jvKu0-0003OP-CQ for larch@yhetil.org; Tue, 14 Jul 2020 09:23:20 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:54328) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1jvKts-0003OE-99 for guix-devel@gnu.org; Tue, 14 Jul 2020 09:23:12 -0400 Received: from fencepost.gnu.org ([2001:470:142:3::e]:58717) by eggs.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1jvKtr-00079K-Vw; Tue, 14 Jul 2020 09:23:11 -0400 Received: from [2a01:e0a:1d:7270:af76:b9b:ca24:c465] (port=37308 helo=ribbon) by fencepost.gnu.org with esmtpsa (TLS1.2:RSA_AES_256_CBC_SHA1:256) (Exim 4.82) (envelope-from ) id 1jvKtr-0001MB-Fo; Tue, 14 Jul 2020 09:23:11 -0400 From: =?utf-8?Q?Ludovic_Court=C3=A8s?= To: Daniela Lura Subject: Re: [Guix Website] A Search Page for Packages References: <878sfnpl9j.fsf@gnu.org> X-URL: http://www.fdn.fr/~lcourtes/ X-Revolutionary-Date: 27 Messidor an 228 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: Tue, 14 Jul 2020 15:23:09 +0200 In-Reply-To: (Daniela Lura's message of "Tue, 14 Jul 2020 11:19:21 +0200") Message-ID: <874kqamds2.fsf@gnu.org> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/26.3 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable 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: -1.01 X-TUID: V1uorbmEaRpD Hi, Daniela Lura skribis: >> To be clear, guix-website-test actually makes a search query on a > Data Service instance, right? > That's right. I'm currently learning how to read and understand query pla= ns: > https://www.postgresql.org/docs/10/using-explain.html#USING-EXPLAIN-ANALY= ZE so that the query can hopefully be optimized. I see. I guess the extra connection from guix.gnu.org to the Data Service means queries will always be a bit expensive, but maybe that=E2=80= =99s OK with optimized queries and caching. Thanks, Ludo=E2=80=99.