InEngineering Under PressurebyThe Systems & Architecture| By Devrim·1h agoWe Deployed One New Column. PostgreSQL Froze 27 Application PodsThe migration contained a single ALTER TABLE statement. It didn’t rewrite the database, yet ordinary queries started timing out. The…
Devrim Ozcay | Founder, ProdRescue·1h agoWe Had Zero Database Errors. Our Customers Were Still Losing PaymentsThe PostgreSQL primary was healthy, the read replicas were available, and every transaction committed successfully. A 300-millisecond…
InEngineering Under PressurebyDevrim Ozcay | Founder, ProdRescue·1h agoPostgreSQL Had 200 GB of Free Disk. One Table Still Stopped Accepting WritesThe API was timing out, database CPU looked normal, and storage wasn’t full. The problem was hiding inside PostgreSQL’s transaction ID…
Devrim Ozcay | Founder, ProdRescue·1h agoPostgreSQL Was Using 8% CPU. Our Spring Boot API Still Took 12 SecondsThe database had spare capacity, the indexes were working, and the connection pool wasn’t exhausted. One PostgreSQL query exposed the…
Devrim Ozcay | Founder, ProdRescue·1h agoWe Doubled Our Database Connections. The API Got Slower. Here’s What We MissedWhy a Spring Boot application can have idle CPU, a healthy PostgreSQL server, and terrible response times and why increasing HikariCP’s…
Staff Engineer Mindset·4h agoThe SQL Migration That Works in Staging Can Destroy Your Production ReleaseSenior engineers aren’t paid to write more complicated SQL. They’re trusted to understand what happens when a perfectly valid change meets…
Victor Magallanes at IT Solutions Network·7h agoUsing Claude to Write Postgres Schema Changes: 4 Ways an ALTER TABLE Blocks Your App, Tested on 2…An ALTER TABLE that takes 0.01 seconds made five ordinary reads wait 3 to 4 seconds. A table rewrite held every reader for 1.7 seconds, and…
Anatolii Zhadan·7h agoPostgres not using your index? It's counting pages, not rowsYou get a Seq Scan even with an index because the planner prices a query in pages, and a small table is cheaper to read whole.
Osazuwa Ngozi blessing·8h agoThis Online Shop Looked Like It Was Growing. It Wasn’t.Revenue went up 1.7%. Orders went down 4%. Here’s what two years of sales data revealed about a UK online gift shop, and what I’d tell its…
