October 2026 - Stormatics

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.

PostgreSQL 18 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.

Your app does not need PostgreSQL superuser

PostgreSQL 18 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