Archive - The Sev-1 Database

How to Find & Fix PostgreSQL Table Bloat with 13 SQL Queries [Full RCA]

A practical guide to Postgres performance tuning, detecting dead tuples, solving sudden latency spikes, and repairing autovacuum failures using real…

Nov 26, 2025 • Haider Z @ Microsoft

[PREMIUM] PostgreSQL Performance Troubleshooting Checklist

Your database is slow. Your users are angry. Here's exactly what to check and in what order.

Feb 26 • Haider Z @ Microsoft

[Premium] PostgreSQL OOM Crash: 11 Diagnostic Queries

How to Diagnose, Fix, and Prevent Linux OOM Killer from Terminating Your Database

Jan 16 • 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

[Premium] PostgreSQL Error That Means It's Already Too Late: invalid page in block

Your queries aren't failing. Your database isn't throwing errors. But your data is already wrong.

Feb 4 • Haider Z @ Microsoft

How Apollo Hospitals Migrated 25 Years of Oracle to PostgreSQL

99.95% uptime. 90% of transactions under 5 seconds. 40% faster deployments. Here’s what happened.

Jan 5 • Haider Z @ Microsoft

PostgreSQL Sev-1 Survival Guide: 15+ Emergency SQL Queries

Production down? Use this guide. Copy-paste SQL queries for lock contention, bloat, and wait events. Resolve PostgreSQL Sev-1 incidents fast.

Nov 28, 2025 • Haider Z @ Microsoft

[Premium] PostgreSQL Disaster: How Unlogged Tables Wiped Out Customer Data + 8 Queries to Prevent It

A PostgreSQL post-mortem that cost $ in lost revenue and 3 months of customer data and how to check if you’re at risk right now

Jan 1 • 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

[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

[Book Review] Mastering PostgreSQL for Oracle Teams: Migration, GoldenGate & Production Tips

Key operational insights from the book, what you can expect. If you come from Oracle world this is for you.

Jan 14 • Haider Z @ Microsoft

Why Your PostgreSQL Query Is Slow: The 7 Checks I Run During Every Sev-1

Step-by-step PostgreSQL query optimization and performance tuning for production systems

Dec 22, 2025 • 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