Engineering Publications
Technical Insights & Architecture Papers
Deep-dives on high-throughput backend architecture, Python & Django performance, real-time Voice AI, and resilient database modeling.
PostgreSQL Zero-Downtime Table Restructuring: Adding Constraints and Altering Types Under 10,000 Writes/Sec
Adding NOT NULL, foreign keys, or altering column types on multi-terabyte PostgreSQL tables requests an AccessExclusiveLock that cascades into queue stalls. Learn zero-lock migration patterns with validated constraints and shadow columns.
PostgreSQL Logical Replication at 100k Changes/Sec: Taming WAL Sender CPU Saturation and Slot Spill Disks
High-velocity write transactions can overwhelm PostgreSQL logical replication workers, spilling Gigabytes to disk and pinning CPUs at 100%. Master logical_decoding_work_mem, in-flight streaming, and pgoutput serialization tuning.