postgresql

Postgres News (Sept 2026): Anonymizer 3.2 CVEs, Migrator 1.0

September’s release week had a clear priority: a security fix. Between September 8 and 14, the PostgreSQL ecosystem shipped a first stable migration tool, a transparent data encryption extension, a cluster-lifecycle platform update, and a masking utility that patches three critical privilege-escalation CVEs. Here is what Houston data teams should act on, in order. PostgreSQL […]

David Sterling 
Performance and tuning

Postgres VACUUM Tuning: Stop Table Bloat from Slowing Queries

Dead tuples are invisible—until they aren’t. On write-heavy workloads—order and status tables, event streams, telemetry from Houston’s energy corridor—every UPDATE and DELETE leaves an old row version behind. PostgreSQL’s MVCC design is why readers never block writers, but the tradeoff is that stale row versions accumulate until autovacuum sweeps them away. When autovacuum falls behind, […]

David Sterling