From mboxrd@z Thu Jan 1 00:00:00 1970 From: Danny Milosavljevic Subject: Re: [Cuirass] Missing database indexes? Date: Mon, 19 Nov 2018 11:44:52 +0100 Message-ID: <20181119114452.5b6777b8@scratchpost.org> References: <87va54yh0c.fsf@gnu.org> <20181110211128.6dc522da@alma-ubu> <87k1ljr1c7.fsf@gnu.org> <20181113003140.1db9c770@scratchpost.org> <87wopfj4m7.fsf@gnu.org> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha256; boundary="Sig_/IV+LrwB+mqEvFQ5nGf84qcF"; protocol="application/pgp-signature" Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:55684) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1gOh3A-00087N-Qc for guix-devel@gnu.org; Mon, 19 Nov 2018 05:45:05 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1gOh36-0001Cc-Mh for guix-devel@gnu.org; Mon, 19 Nov 2018 05:45:04 -0500 In-Reply-To: <87wopfj4m7.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@gnu.org, clement@lassieur.org --Sig_/IV+LrwB+mqEvFQ5nGf84qcF Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Hi Ludo, >It doesn=E2=80=99t seem to help much, perhaps because the query is too com= plex? Yeah, probably. According to the docs a log message is supposed to appear when it is doing = it. We should just special-case the common queries so the optimizer has a easier life. --Sig_/IV+LrwB+mqEvFQ5nGf84qcF Content-Type: application/pgp-signature Content-Description: OpenPGP digital signature -----BEGIN PGP SIGNATURE----- iQEzBAEBCAAdFiEEds7GsXJ0tGXALbPZ5xo1VCwwuqUFAlvylCQACgkQ5xo1VCww uqXuTAf+Jjm7p8Xq6yXySMNCsuC6AuxN9iBiLaqqo2gBrcSFHe7hUk2l5DyUBZWR vwdauBt3P/wyCShgt4xEpXg2AZRFx6ffIYx/MoiLpvz/pveEz8tRgj1Z8UBIjaEB Fq2IDYO8mU8/RtPFI5G5OaGDkYeIYafF9emNtCqWPBAk3iSLZgWzDbGWwh064SQP ZpMH1Lp8eynx9ebbZuX80h7x6fopkBMleTn1cKxzSxPvctGCMX1Ac3Fi+HFa79op 4XLq51qzbnKemVksr7TxG8//UigNGo0LLmrgXiS3xkSMwcjMFLUcl/jMX2M3jwyH d9R44y+QsDlKF9uU9MihsJY8xYekBQ== =XTcU -----END PGP SIGNATURE----- --Sig_/IV+LrwB+mqEvFQ5nGf84qcF--