From mboxrd@z Thu Jan 1 00:00:00 1970 From: Amirouche Boubekki Subject: Re: [Cuirass] Missing database indexes? Date: Wed, 19 Dec 2018 23:45:26 +0100 Message-ID: References: <87va54yh0c.fsf@gnu.org> <20181110211128.6dc522da@alma-ubu> <87k1ljr1c7.fsf@gnu.org> <20181113003140.1db9c770@scratchpost.org> <87wopfj4m7.fsf@gnu.org> <20181119114452.5b6777b8@scratchpost.org> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="000000000000d6d3ba057d67c560" Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:36879) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1gZkay-0003yH-II for guix-devel@gnu.org; Wed, 19 Dec 2018 17:45:41 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1gZkax-0006hy-TM for guix-devel@gnu.org; Wed, 19 Dec 2018 17:45:40 -0500 In-Reply-To: <20181119114452.5b6777b8@scratchpost.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: Danny Milosavljevic Cc: guix-devel , =?UTF-8?Q?Cl=C3=A9ment_Lassieur?= --000000000000d6d3ba057d67c560 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Did you consider using wiredtiger? Le lun. 19 nov. 2018 =C3=A0 11:47, Danny Milosavljevic a =C3=A9crit : > Hi Ludo, > > >It doesn=E2=80=99t seem to help much, perhaps because the query is too c= omplex? > > Yeah, probably. > > According to the docs a log message is supposed to appear when it is doin= g > it. > > We should just special-case the common queries so the optimizer has a > easier life. > --000000000000d6d3ba057d67c560 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Did you consider using wiredtiger?

Le=C2=A0lun. 19 nov. 2018 =C3=A0=C2=A011:= 47, Danny Milosavljevic <danny= m@scratchpost.org> a =C3=A9crit=C2=A0:
Hi Ludo,

>It doesn=E2=80=99t seem to help much, perhaps because the query is too = complex?

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.
--000000000000d6d3ba057d67c560--