Blog Archives - Stormatics

Your Postgres Database Is Slow, and It Isn’t Postgres

When every PostgreSQL setting is right and reads are still slow, look at the storage underneath. Four Azure disk traps, from the 4 TiB caching cliff to VM I/O caps, and how to spot them.

Partitioning Four PostgreSQL Tables at Scale, Without a One-Size-Fits-All Answer

Four production tables, two very different partitioning strategies. See how real dependency and skew data, not convention, shaped a zero-downtime migration, and the two silent bugs caught before they ever reached production.

How to De-Risk a Mission-Critical PostgreSQL Migration

Speed is the wrong finish line for a mission-critical PostgreSQL migration. This field-tested method covers defining success in numbers, validating data at three checkpoints, rehearsing against a production copy, following a runbook, and keeping a rollback path open until sign-off.

Database Availability Is a Stack: Rolling OS Patching

Why a routine kernel or glibc update keeps taking databases down, and how a rolling, node-by-node OS patch on a Patroni-managed cluster keeps Postgres up through every reboot.

How Fast Should You Patch Production PostgreSQL?

PostgreSQL's August 2026 release closed 28 CVEs in a single day, a record. The fix itself is a fast binary swap. What actually determines your risk is how long it takes you to apply it. Here's how to set a patch SLA and hit it without breaking production.

How to Calculate Fillfactor for Your Tables

Fillfactor is one of those settings people either leave alone or guess at. Here's how to calculate a real starting number from your own table data, with the formula and a query to run it.

CloudNativePG: How to Run PostgreSQL on Kubernetes

CloudNativePG on Kubernetes: automated failover, three-zone HA, security defaults, backups, vs. Patroni and pgpool-II.

Cutting a Production PostgreSQL Database’s WAL Generation by ~25%: A Diagnostic Story

How Stormatics diagnosed a PostgreSQL database generating 1.8TB of WAL daily, and used a systematic, evidence-first approach to project a 25% reduction.

Choosing the Right PostgreSQL Partition Key

The partition key is the one partitioning decision you mostly cannot undo. Here is how to choose it, why hash on a skewed column backfires, and how to match the key to your workload.

PostgreSQL Lockup vs Stale Connection: How to Tell Them Apart

Two failure modes produce the same "database is locked up" alert in PostgreSQL. Here is how to tell a true lockup from a stale connection, and fix the right one.

Your Postgres Database Is Slow, and It Isn’t Postgres

Partitioning Four PostgreSQL Tables at Scale, Without a One-Size-Fits-All Answer

How to De-Risk a Mission-Critical PostgreSQL Migration

Database Availability Is a Stack: Rolling OS Patching

How Fast Should You Patch Production PostgreSQL?

How to Calculate Fillfactor for Your Tables

CloudNativePG: How to Run PostgreSQL on Kubernetes

Cutting a Production PostgreSQL Database’s WAL Generation by ~25%: A Diagnostic Story

Choosing the Right PostgreSQL Partition Key

PostgreSQL Lockup vs Stale Connection: How to Tell Them Apart

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