Insights
Thoughts on product engineering, software architecture, AI, and digital systems.
We share ideas, lessons, and practical perspectives from the world of software products, engineering decisions, cloud systems, and emerging technology.
Database Engineering · 2 October 2026 · 15 min read
Rebuilding a 1.2 TB Live Table Without a Maintenance Window
How do you rebuild a 1.2 TB PostgreSQL table with hundreds of millions of rows without taking production offline? Discover how ANC engineers used partitioning, controlled data migration, and carefully orchestrated cutovers to reclaim 929 GB of storage and improve query performance by up to 25×—while keeping ETL pipelines and live dashboards running.
Database Engineering · 16 September 2026 · 30 min read
313 Million Dead Tuples: What Partitioning a 1 TB PostgreSQL Table Actually Taught Us
We moved 788 million rows onto partitioned tables across six deployments. Five went missing during one cutover — and finding them taught us more than the clean migrations did.