Archive - The Sev-1 Database

[PREMIUM] PostgreSQL Autovacuum Diagnostic: 10 Queries to Know It's Running or Winning

Autovacuum running and autovacuum winning are different things.

10 hrs ago • Haider Z @ Microsoft

A Small Support From Me to You

Affected by layoffs? or in search of Job?

May 7 • Haider Z @ Microsoft

[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

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

April 2026

[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

[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

[PREMIUM] PostgreSQL Query Plan Diagnostic with 9 Queries

When PostgreSQL Ignores Your Index and Chooses a Sequential Scan

Apr 21 • Haider Z @ Microsoft

[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

[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

[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

Unlock Full Sev1 Database Premium Access 🚀

Hey, You’ve seen the free insights.

Apr 4 • Haider Z @ Microsoft

[PREMIUM] PostgreSQL WAL Troubleshooting: 9 Diagnostic Queries

Diagnostic Queries for WAL Pressure, Replication Slot Lag, and Archive Failures

Apr 3 • Haider Z @ Microsoft

#nojs-banner { position: fixed; bottom: 0; left: 0; padding: 16px 16px 16px 32px; width: 100%; box-sizing: border-box; background: red; color: white; font-family: -apple-system, "Segoe UI", Roboto, Helvetica, Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol"; font-size: 13px; line-height: 13px; } #nojs-banner a { color: inherit; text-decoration: underline; } This site requires JavaScript to run correctly. Please turn on JavaScript or unblock scripts