profile picture

Blog

Maxing out max_parallel_workers in Postgres

February 22, 2023 - 937 words - 5 mins
There are a number of articles which discuss how to force the postgres query planner into a certain amount of parallelism (1, 2). Today I was trying to get a query to run with up to 64 parallel workers (for reasons), but ran into something which the other articles didn't mention explicitly. To recap… read more

Docker-based Nix builders on macOS

December 19, 2022 - 338 words - 2 mins
This is a quick one, more of an addendum to my last blog post. In that, I shared info on mostly ranted about deploying to NixOS on a Raspberry Pi from macOS. The main thing that I achieved in that post was configuring a docker-based nix builder for NixOS. Taking a look at that post again, I realised… read more

Deploying NixOS on a Raspberry Pi from a Mac (Part 1)

August 26, 2022 - 1714 words - 9 mins
In my last blog post, I documented setting up NixOS on a Raspberry Pi. That Pi has gone on to get a number of services installed on it, and I'm having fun with it. I've also acquired another Pi which I'm using as my internet router. That's really a story for another time, but suffice to say the Comp… read more

NixOS on Raspberry Pi 4

September 14, 2021 - 2215 words - 12 mins
I've had a Raspberry Pi 4 knocking around for a while. I'd been meaning to install NixOS on it but didn't really have the time. That may have worked to my advantage, because NixOS has much better support for the Raspberry Pi 4 now, but it was still a bit of a challenge. The following documents the … read more

Hello World!

June 27, 2021 - 465 words - 3 mins
Welcome to my blog! Setting up this blog has been a project in itself. I would like to explain some pieces over the next few blog articles. This article should give a sense of what, and why. When I decided that I wanted to have a website again, I realised that I could either do things the simple way… read more