2024 Lock Contention on Google Cloud SQL and Postgres
I recently looked into some performance issues on a large PostgreSQL 13.12 instance. One part of that was to make sure we don’t have too much locking going on in busy tables.
As it turns out, I do have a hostname.
I recently looked into some performance issues on a large PostgreSQL 13.12 instance. One part of that was to make sure we don’t have too much locking going on in busy tables.
In 2023 I spent two months in Hong Kong, here’s a small subset of places that I remember and liked. More inspiration for places to visit are in my vlog episodes I shared in a previous post. There’s a lot of things missing but half the fun is finding places yourself anyway.
This year I started playing around with creating video content. The goal was to create low-effort semi-frequent video summaries of what I have been up to. I didn’t want to do narration or anything else that would raise the barrier of publishing a video.
All videos are available on my YouTube channel...
After hearing about Nostr from multiple people over the past weeks I decided to take a look and learn more about it. I found nostr-resources.com, usenostr.org and github.com/aljazceru/awesome-nostr to be helpful to get an initial overview.
As a next step I looked into setting...
Recently I ran into the issue where installing an EPSON SC-P900 printer driver on macOS (before and after the update to Ventura) always failed with a generic “Installation failed” message.
I started my investigation by looking at the installation log with the following command while...
If you want to post a video on Twitter there’s a few rules that are important for the video to be accepted.
Unfortunately the interface will only show “The video file is not compatible” while only the actual API request in the background will tell you exactly what is wrong. If you...
I’m using AppSignal to monitor Birdfeeder. Birdfeeder’s job is to send your Twitter bookmarks to your email inbox so you don’t forget about them.
On the technical side it’s a Rails app which relies on Sidekiq to process background jobs. Bookmarks have to be fetched, accounts...
A few weeks ago I rebuilt a GitLab CI pipeline at JustWatch. One part of that was to move the step building the container images in the Kubernetes cluster from artificer to kaniko.
I wrote up a short guide on the JustWatch blog in case you are curious.
Today I was reading a comment on HN that piqued my interest.
I used to rip the audio of my favourite movies and listen to them like audiobooks. Because I was usually familiar with the visual parts, I could enjoy the dialogue and the music in a different way.
This sounded like a simple enough task...
Until now Birdfeeder was powered by a self-hosted Postgres instance which is used by various other side projects. It was running out of space and decided to migrate to a managed Postgres instance on DigitalOcean (Affiliate link, giving you $100 in credits).
The reason for going managed was that I...