Christopher Baines @cbaines@octodon.social

I probably should be doing something more important than fixing thumbnails for the Gnome Font Viewer in #Guix, but that's what I find myself doing...

Running pg_restore seems to be a surefire way of getting what I believe is the controller on my NVMe SDD to heat up a bit...

I should probably buy a big heat sink for it.

I supposedly know some things about computers, but that apparently doesn't include why my computer says pretty much all of the 60GB of swap space is being used 😦

How many inputs does an average #guix derivation have? Around 31 is my guesstimate from the Guix Data Service data.

This sort of chart might show some more nuances though, there's probably some reason why 3, 6, 10 and 25 are quite popular...

I'm starting to wonder how much of my PostgreSQL query performance problem is down to my M.2 SSD running at +95.8C degrees...

I have a theory as to why this worked. I think the database was returning builds in a sensible order, because the derivations are inserted in to the database in a sensible order, each derivation is inserted after it's inputs.

This is rather more luck than judgement, but for now I'm happy to take it. Funnily enough, as some code in the allocator was reversing the order, that meant the performance was quite poor. Reversing the reverse to maintain the apparently good order did the trick :)

Wooo! Turns out that adding (reverse ...) in a couple of places was enough to get the #guix Build Coordinator ordering builds in a pretty sensible way.

https://git.cbaines.net/guix/build-coordinator/commit/guix-build-coordinator?id=869e9db797201691cbb55aa08a615ee662e43cdc

I'm pretty sure that change meant that suddenly agents were mostly allocated builds that they could actually attempt, rather than ones where the inputs were missing.

Back when I was using #Debian and first found out about #Guix , I didn't think it was possible or useful to have a package manager without a dependency resolver. I'd literally spent time working on dependency resolver stuff in APT: https://www.cbaines.net/projects/gsoc/2011/

I'm glad I was wrong though, I think Guix is so much better for not having a dependency resolver run when you try to install packages.

I'm reminded about this by the troubles I see people still trying to use pip for #Python , just use Guix!

Once again I've accidentally set the goal column in #emacs

At least I'm getting used where to find the key combination to unset it: C-u C-x C-n

I spend too much time staring at dashboards...

Maybe I'm seeing them like other people see art in the typical sense...

I'm excited for the #Guix Day tomorrow!

https://guix.gnu.org/en/blog/2020/online-guix-day-announce-2/

Another day, yet more evidence that I still can't write code that actually uses SQLite in a way that doesn't fail in novel ways 😦