Dkam's Blog
  • Home
  • TIL
  • Booko
Sign in Subscribe

Nipsu

  • Dan Milne

Dan Milne

15 Aug 2025
Nipsu
Enter your email
Subscribe

Migrating PostgreSQL across the planet, with almost no downtime.

TL;DR: Using PostgreSQL logical replication and Tailscale VPN, I migrated 200GB of data from California to Sydney with seconds of downtime and no time pressure. The replica synchronized over several days while production ran normally.
07 Aug 2025 7 min read

Using PostgreSQL Tablespaces on your VPS

Moving PostgreSQL indexes to the local NVMe drive from Hetzner's remote volumes boosted TPS by 86% (3,161→5,870). Using tablespaces to split storage between fast local and slower remote disks gives massive performance gains for free when your database is too big for the local drive alone.
04 Aug 2025 5 min read

When an esoteric bug gives you a crisis of confidence.

I'm building a little toy / passion project app for saving bookmarks and archiving what they link to. It's Ruby on Rails, with TailwindCSS and Phlex components. It's very vanilla Rails. When I built a cross platform image for it on my ARM64 Mac, and
27 Jul 2025 3 min read
Dkam's Blog © 2025
Powered by Ghost