Re: [PATCH] sql: Add a couple of indexes.

2020-06-15 Thread Christopher Baines
zimoun writes: > Hi Chris, > > On Sun, 14 Jun 2020 at 12:48, Christopher Baines wrote: > >>> --8<---cut here---start->8--- >>> 65.7% substitutes available (9,425 out of 14,354) >>> at least 57,816.3 MiB of nars (compressed) >>> 97,343.9 MiB on disk

Re: [PATCH] sql: Add a couple of indexes.

2020-06-15 Thread zimoun
Hi Chris, On Sun, 14 Jun 2020 at 12:48, Christopher Baines wrote: >> --8<---cut here---start->8--- >> 65.7% substitutes available (9,425 out of 14,354) >> at least 57,816.3 MiB of nars (compressed) >> 97,343.9 MiB on disk (uncompressed) >> 0.010

Re: [PATCH] sql: Add a couple of indexes.

2020-06-14 Thread Christopher Baines
zimoun writes: > Hi Chris, > > On Sat, 13 Jun 2020 at 17:29, Christopher Baines wrote: > >> I've pushed a rebased version of this patch now. I've also recofigured >> bayfront to apply these changes. Checking with guix weather, I think it >> might be helping. > > Nice! > > What about

Re: [PATCH] sql: Add a couple of indexes.

2020-06-13 Thread zimoun
Hi Chris, On Sat, 13 Jun 2020 at 17:29, Christopher Baines wrote: > I've pushed a rebased version of this patch now. I've also recofigured > bayfront to apply these changes. Checking with guix weather, I think it > might be helping. Nice! What about reconfigure ci.guix.gnu.org and close

Re: [PATCH] sql: Add a couple of indexes.

2020-06-13 Thread Christopher Baines
Christopher Baines writes: > Remove the Builds_index from the schema, as it would have been removed in > error by the upgrade-6 upgrade. Add a specific index on the Builds status > field, as this helps with db-get-builds queries, and add an index on the > Outputs derivation field, as this

[PATCH] sql: Add a couple of indexes.

2020-06-09 Thread Christopher Baines
Remove the Builds_index from the schema, as it would have been removed in error by the upgrade-6 upgrade. Add a specific index on the Builds status field, as this helps with db-get-builds queries, and add an index on the Outputs derivation field, as this helps with the db-get-outputs part of