Tag
#PostgreSQL
5 articles tagged with this topic.
Software Engineering
Beyond the Vertical Limit: A No-Nonsense Guide to Database Sharding in 2026
Your r7g.metal instance is at 90% CPU and vertical scaling has hit its ceiling. It is time to talk about the most complex transition in a backend engineer's career: Database Sharding.
June 8, 20266 min read
Automation
Stop Manual DB Changes: A Senior Engineer's Guide to Schema Evolution in 2026
Manual database migrations are a relic of the past. Learn how to automate schema evolution with zero downtime using modern tools like Atlas, declarative workflows, and CI-integrated linting.
June 6, 20265 min read
Software Engineering
Database Sharding: When to Scale Out and How to Survive It
When your RDS bill hits $20k/month and P99s are still spiking despite maxing out vertical specs, it's time to shard. But do it wrong, and you'll spend the next two years fixing your mistake.
May 7, 20267 min read
Automation
Automating Database Evolution: Lessons from the Production Trenches
Manual database changes are a ticking time bomb. I’ve seen $80k/hour downtime events caused by a simple index creation. Here is how I build zero-downtime migration pipelines using Atlas, Flyway, and the Expand-and-Contract pattern.
April 19, 20265 min read
Software Engineering
PostgreSQL Performance Optimization Guide
Advanced techniques for optimizing PostgreSQL performance: indexing strategies, query optimization, and configuration tuning.
December 18, 20241 min read