The Sev-1 Database
Subscribe
Sign in
Home
Notes
Real RCAs
PostgreSQL Insights
Database Engineering
Sev 1 Premium
DBA Toolkit
About
[DBEng] How Instagram Sharded PostgreSQL With 2.5 Engineers
In September 2011, Instagram was serving 10 million+ users on EC2 with two-and-a-half engineers and no ops team.
May 12
•
Haider Z @ Microsoft
2
[PREMIUM] PostgreSQL Autovacuum Diagnostic: 10 Queries to Know It's Running or Winning
Autovacuum running and autovacuum winning are different things.
May 8
•
Haider Z @ Microsoft
A Small Support From Me to You
Affected by layoffs? or in search of Job?
May 7
•
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 Error That Means It's Already Too Late: invalid page in block
Feb 4
•
Haider Z @ Microsoft
5
[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
How Apollo Hospitals Migrated 25 Years of Oracle to PostgreSQL
Jan 5
•
Haider Z @ Microsoft
5
Latest
Top
Discussions
[FREE] 1979 Paper Still Running Your PostgreSQL Optimizer
Here's what Patricia Selinger designed, what survived 46 years, and what you need for PostgreSQL.
May 5
•
Haider Z @ Microsoft
3
I know this stuff. But in the interview I freeze. Kit I built for this
31 questions. Weak answer vs strong answer. What the interviewer is actually scoring
May 1
•
Haider Z @ Microsoft
3
[PREMIUM] PostgreSQL Extended Statistics Diagnostic with 8 Queries
Last week I wrote about the VLDB paper that proved PostgreSQL’s independence assumption drives most bad plans. Here are the 8 queries I use to find…
Apr 28
•
Haider Z @ Microsoft
1
[FREE] VLDB Paper Explains Why PostgreSQL Chooses Bad Plans
In 2015, four researchers proved what every DBA already knew. Ten years later, PostgreSQL 18 ships with the same fundamental limitation. Here’s what…
Apr 24
•
Haider Z @ Microsoft
1
[PREMIUM] PostgreSQL Query Plan Diagnostic with 9 Queries
When PostgreSQL Ignores Your Index and Chooses a Sequential Scan
Apr 21
•
Haider Z @ Microsoft
1
[DBEng] How Figma Keeps PostgreSQL Fast at Scale
Figma’s core product is a real-time multiplayer collaboration database problem.
Apr 14
•
Haider Z @ Microsoft
3
[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.
Apr 10
•
Haider Z @ Microsoft
2
[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
4
Unlock Full Sev1 Database Premium Access 🚀
Hey, You’ve seen the free insights.
Apr 4
•
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
