The Sev-1 Database
Subscribe
Sign in
Home
Notes
🚀 New platform
PostgreSQL Insights
Database Engineering
Sev 1 Premium
DBA Toolkit
Real RCAs
About
[Free] Challenge #1: Distributed PostgreSQL with Citus
Adding a worker is not just adding compute. In a distributed PostgreSQL cluster, it requires replaying the database's entire logical identity.
Aug 30
•
Haider Z @ Microsoft
[Premium] Engine: How Replication Slots Guarantee WAL Retention
Why your PostgreSQL primary chose to crash with a full disk rather than break a promise to a dead replica.
Aug 27
•
Haider Z @ Microsoft
1
Postgres Is Down. Now What?
SQL, lessons, runbooks now with a 7-day Pro trial
Aug 19
•
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
New Platform 𝗘𝗮𝗿𝗹𝘆 𝗔𝗰𝗰𝗲𝘀𝘀 𝗶𝘀 𝗻𝗼𝘄 𝗼𝗽𝗲𝗻
The Sev-1 Database Platform shows you what to run when production is on fire.
Aug 7
•
Haider Z @ Microsoft
2
1
[DBEng] Azure HorizonDB: Microsoft’s Cloud-Native Distributed PostgreSQL
Compute ships the log; storage turns it into the database and how that sets Microsoft's new Postgres apart from Aurora, AlloyDB, and Neon.
Jul 24
•
Haider Z @ Microsoft
1
[PREMIUM] PostgreSQL Deadlock RCA: reproducing and killing 40P01 for good
A full PostgreSQL deadlock RCA from a real reproduction
Jul 20
•
Haider Z @ Microsoft
2
PG Mood Ring: What's This?
Lately, I’ve started asking myself one question after every PostgreSQL production incident:
Jul 17
•
Haider Z @ Microsoft
SQL Server → Postgres Migration Nobody Talks About
Fragmentation Bug That Can Cost You Weeks
Jul 14
•
Haider Z @ Microsoft
4
[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
[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
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
