Blog Archives - Stormatics

PostgreSQL, NUMA, and the Cloud

Part 4 of our NUMA series. How virtual machines, Docker and Kubernetes change NUMA behaviour for PostgreSQL in the cloud, and what to do about it.

PostgreSQL Minor Version Upgrade on RHEL 9: A Step-by-Step Guide with Rollback

A minor PostgreSQL upgrade is one dnf command. The real risk is the server not coming back. Here is the preparation, verification and rollback plan that keeps patch night quiet.

When PostgreSQL JIT Compilation Adds More Overhead Than Benefit

JIT compilation can make PostgreSQL queries faster, or much slower. Two side-by-side tests show when it pays off, when it backfires, and how to check your own workload.

PostgreSQL Bloat and VACUUM 101: A Beginner’s Guide

Why does a PostgreSQL table grow when the row count stays the same? This beginner’s guide uses pageinspect to show how MVCC and dead tuples cause table bloat.

Your backups are green. That does not mean you can restore.

Your backup dashboard is green, but has anyone ever brought a backup back? Here is why a successful backup job is a much smaller claim than people think, and the one test that proves you can recover.

Your app does not need PostgreSQL superuser

A PostgreSQL superuser can read any file on the server, write to it, and run shell commands on the host. Here is why your app does not need it, and how to scope any tool or agent down.

Forthcoming Patches and libnuma

PostgreSQL 18 can be built with libnuma support. Part 3 of our NUMA series explains what Tomas Vondra's patch set changes and which tuning advice still applies.

How to Backfill Compressed TimescaleDB Chunks Without Running Out of Disk

A narrow backfill into compressed TimescaleDB chunks can still decompress far more data than expected. This workflow keeps every batch bounded, vacuumed, and recompressed.

The Database Restarted Without Restarting: The Basics of PostgreSQL Signals (Part 1)

Signal 1 should only reload PostgreSQL's config, so why did it trigger crash recovery? Part 1 covers PostgreSQL signals and the postmaster.

Migrating a Patroni Cluster Without Losing an In-Flight Update: A Logical Replication Story (Part 1)

Part 1 of a live Patroni-to-EFM migration: how a trigger-based capture table closes a silent data-loss race, and how low-cost PostgreSQL logical replication monitoring tracks drift between source and target.

PostgreSQL, NUMA, and the Cloud

PostgreSQL Minor Version Upgrade on RHEL 9: A Step-by-Step Guide with Rollback

When PostgreSQL JIT Compilation Adds More Overhead Than Benefit

PostgreSQL Bloat and VACUUM 101: A Beginner’s Guide

Your backups are green. That does not mean you can restore.

Your app does not need PostgreSQL superuser

Forthcoming Patches and libnuma

How to Backfill Compressed TimescaleDB Chunks Without Running Out of Disk

The Database Restarted Without Restarting: The Basics of PostgreSQL Signals (Part 1)

Migrating a Patroni Cluster Without Losing an In-Flight Update: A Logical Replication Story (Part 1)

Our Projects

Quick Links

Contact Info

USA: 5900 Balcones Drive Ste 100, Austin, Travis County, TX 78731

Singapore: 20A Tanjong Pagar Road, 088443

Follow us at

Archives

Categories