From mboxrd@z Thu Jan 1 00:00:00 1970 From: Danny Milosavljevic Subject: Re: Cuirass news Date: Sat, 3 Mar 2018 00:29:57 +0100 Message-ID: <20180303002957.42ccb184@scratchpost.org> References: <877es6x5xj.fsf@gnu.org> <87lggmjjgo.fsf@gmail.com> <87k1w6jjak.fsf@gmail.com> <87h8raxeym.fsf@gnu.org> <20180126153005.259a75e8@scratchpost.org> <87zi4z1eb0.fsf@gnu.org> <20180127181852.42f0bcbf@scratchpost.org> <87fu6bwqix.fsf@gnu.org> <20180208172905.19e9e789@scratchpost.org> <871shvt94p.fsf@gnu.org> <20180209000526.5b9ea8e7@scratchpost.org> <87wozm4i12.fsf@gnu.org> <20180209122931.5a47e63e@scratchpost.org> <877ermyuj2.fsf@gnu.org> <20180209180608.79fb856b@scratchpost.org> <874lmpw0rj.fsf@gnu.org> <20180213101236.5c74e577@scratchpost.org> <87zi4bsn37.fsf@gnu.org> <877erfqhy4.fsf@gnu.org> <20180219163506.2037e56e@scratchpost.org> <20180219230843.09660e23@scratchpost.org> <87r2p2fw98.fsf@gnu.org> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha256; boundary="Sig_/ZJcRmtvdBb/G6Fi=_CC3+ST"; protocol="application/pgp-signature" Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:51093) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1eru7v-00035j-Ay for guix-devel@gnu.org; Fri, 02 Mar 2018 18:30:12 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1eru7s-00078F-6f for guix-devel@gnu.org; Fri, 02 Mar 2018 18:30:11 -0500 In-Reply-To: <87r2p2fw98.fsf@gnu.org> 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+gcggd-guix-devel=m.gmane.org@gnu.org Sender: "Guix-devel" To: Ludovic =?ISO-8859-1?Q?Court=E8s?= Cc: guix-devel --Sig_/ZJcRmtvdBb/G6Fi=_CC3+ST Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable > Inlining output fetching does not quite have the performance impact I > was hoping for. For example, /api/queue remains quite slow (sometimes a > tenth of a second but often several seconds.) The problem might be > elsewhere though, perhaps some Fiber scheduling issue. Hmm, we could examine the query plan and see what's up with it. I don't think this specific SELECT can be made any faster anymore by rewriting the SELECT - but maybe by adding indices or reordering data (index statistics). --Sig_/ZJcRmtvdBb/G6Fi=_CC3+ST Content-Type: application/pgp-signature Content-Description: OpenPGP digital signature -----BEGIN PGP SIGNATURE----- iQEzBAEBCAAdFiEEds7GsXJ0tGXALbPZ5xo1VCwwuqUFAlqZ3nUACgkQ5xo1VCww uqXg1wf/Z8lIalW3U2GGdrdchHmWqeeDKx0ne+oXDZYLZB7MMQdkxzt2z8Pi+B5+ rI9/H2sY/AhItbEUAyCHp0iSzWG99+49zdexWehlYMMvaGFBEYbKCskgiBy0Zb+t gDrsnOyWdbXDEqsUs2roL+2t11qmhhwrZs+NMduuNZ9sRba9tEB5MClOj36OEjNR tEZ8Egrf6nzp3101sgiRgaMIrvJQRKtlfsrb5sRzEYFcxPI9+TKrLVuNv3qkN3iE lfVrw7vUieqPW3TeRVEeEt1jU5Aj0hjRDvnarTQoSwmQmysmprkY4JfsVUmIhc+N a1t90x8Wxp/1sL9Ez2yB9tzEdvuTPg== =owKy -----END PGP SIGNATURE----- --Sig_/ZJcRmtvdBb/G6Fi=_CC3+ST--