The Sev-1 Database
Subscribe
Sign in
Home
Real RCAs
PostgreSQL Insights
Database Engineering
Sev 1 Premium
DBA Toolkit
About
[PREMIUM] PostgreSQL Sev-1 Prevention Checklist
Slow query checklist tells you what’s broken right now. This one tells you what will break next week before your users find out first.
10 hrs ago
•
Haider Z @ Microsoft
[DBEng] How Stripe Handles 500M+ Database Writes Per Day
Stripe didn’t use MySQL or PostgreSQL for their core storage layer. They built their own a MongoDB-compatible distributed database called DocDB.
Apr 7
•
Haider Z @ Microsoft
1
Unlock Full Sev1 Database Premium Access 🚀
Hey, You’ve seen the free insights.
Apr 4
•
Haider Z @ Microsoft
1
Most Popular
View all
How to Find & Fix PostgreSQL Table Bloat with 13 SQL Queries [Full RCA]
Nov 26, 2025
•
Haider Z @ Microsoft
7
[PREMIUM] PostgreSQL Performance Troubleshooting Checklist
Feb 26
•
Haider Z @ Microsoft
4
[Premium] PostgreSQL OOM Crash: 11 Diagnostic Queries
Jan 16
•
Haider Z @ Microsoft
4
[PREMIUM] PostgreSQL WAL Troubleshooting: 9 Diagnostic Queries
Apr 3
•
Haider Z @ Microsoft
4
[Premium] PostgreSQL Error That Means It's Already Too Late: invalid page in block
Feb 4
•
Haider Z @ Microsoft
4
How Apollo Hospitals Migrated 25 Years of Oracle to PostgreSQL
Jan 5
•
Haider Z @ Microsoft
5
Latest
Top
Discussions
[PREMIUM] PostgreSQL WAL Troubleshooting: 9 Diagnostic Queries
Diagnostic Queries for WAL Pressure, Replication Slot Lag, and Archive Failures
Apr 3
•
Haider Z @ Microsoft
4
[PREMIUM] Silent PostgreSQL Memory Killer
Technical deep-dive for PostgreSQL administrators, backend engineers, and platform teams running PostgreSQL on Linux. If you manage a database with…
Mar 31
•
Haider Z @ Microsoft
2
[FREE] PostgreSQL ALTER TABLE Lock: How Lock Cascaded Outage
Here’s the PostgreSQL locking behavior that caused it and the safe DDL pattern that prevents it.
Mar 27
•
Haider Z @ Microsoft
4
1
[Free] Understand PostgreSQL EXPLAIN ANALYZE Plan
Most engineers run EXPLAIN ANALYZE. Lets learn how to read what it means.
Mar 24
•
Haider Z @ Microsoft
3
Ask Me Anything – The Sev 1 Database Newsletter
Opening this space for you to ask me questions
Mar 20
•
Haider Z @ Microsoft
2
[FREE] PostgreSQL WAL Setting Nobody Changes Until It Causes Data Loss
Most engineers set wal_level = replica and never touch it again. Here’s what the documentation actually says and why it matters.
Mar 13
•
Haider Z @ Microsoft
[RCA] DELETE That Took Down Production for 3 Hours
A routine cleanup job. A 30-second maintenance window. And a database that refused to commit.
Mar 10
•
Haider Z @ Microsoft
1
[FREE] PostgreSQL Migration You Need to Read Before Moving to the Cloud
What nobody tells you about moving your PostgreSQL database off-prem and the one setting that turned a disaster into a success.
Mar 6
•
Haider Z @ Microsoft
[Premium] PostgreSQL Query Performance Debugging: Techniques Beyond EXPLAIN ANALYZE
Methods DBAs and SREs use to catch performance problems that EXPLAIN ANALYZE alone will never show you
Mar 3
•
Haider Z @ Microsoft
2
See all
The Sev-1 Database
I manage PostgreSQL, MySQL and MariaDB at Microsoft. Each week, I share practical takeaways from real incidents no theory, just what actually breaks and how to fix it.
Subscribe
The Sev-1 Database
Subscribe
About
Archive
Sitemap
This site requires JavaScript to run correctly. Please
turn on JavaScript
or unblock scripts
