PostgreSQL - Dkam's Blog

Dkam's Blog

Sign in Subscribe

PostgreSQL

A collection of 3 posts

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.

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.

TIL 20250228

Today I learnt that ALTER SYSTEM SET max_connections = 100; writes a new configuration file in the data directory for PostgreSQL, postgresql.auto.conf which takes priority over the values in the normal postgresql.config file. It's especially pointless to use ALTER SYSTEM for max_connections because you