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

[zimoun]

Hi Chris,

On Sat, 13 Jun 2020 at 17:29, Christopher Baines <mail@cbaines.net> 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 bug#41708?

http://issues.guix.gnu.org/issue/41708


> → guix weather --substitute-urls=https://bayfront.guix.gnu.org

[...]

>   13.8% (897 out of 6,519) of the missing items are queued
>   at least 1,000 queued builds
>       x86_64-linux: 1000 (100.0%)
>   build rate: 9.34 builds per hour
>       x86_64-linux: 9.34 builds per hour

I think it is the first I see these results instead of the 504. :-)
With "guix e782756", it is:

--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 seconds per request (138.1 seconds in total)
  103.0 requests per second

  0.0% (0 out of 4,929) of the missing items are queued
  at least 1,000 queued builds
      x86_64-linux: 1000 (100.0%)
  build rate: 9.20 builds per hour
      x86_64-linux: 9.20 builds per hour
--8<---------------cut here---------------end--------------->8---

Hum?  Almost 1/3 of substitutes are not available and in the same time
not queued.  Is it expected?  Does it mean that 1/3 of the builds are
failing?


All the best,
simon