The Sev-1 Database

The Sev-1 Database

Home
Real RCAs
PostgreSQL Insights
Database Engineering
Sev 1 Premium
DBA Toolkit
About

PostgreSQL Insights

[FREE] Why Query Performance Degrades and Causes High CPU
Stale Statistics, Reset Stats, and Missing ANALYZE: The Hidden Causes Behind Query Plan Regressions
 • Haider Z
[FREE] Why Linux Kills PostgreSQL: What the Manual Says (And How to Fix It)
The official documentation explains exactly how to prevent Linux from killing your database. Here's what it says.
 • Haider Z
How Partition Key UPDATE Cause Serialization Failures
Why PostgreSQL triggers SQLSTATE 40001 during row movement and the architectural patterns to prevent it.
 • Haider Z
Temporary Tables and TempDB: The Hidden Performance Killer in Your Database
How Oracle, SQL Server, MySQL and PostgreSQL handle temporary data differently and why it matters for production stability.
 • Haider Z
Last Tip of 2025 That Will Boost Your PostgreSQL Performance OFFSET vs KEYSET
PostgreSQL OFFSET/LIMIT pagination gets slower as pages get deeper. Here’s how to use keyset (seek/cursor) pagination with the right index for…
 • Haider Z
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
 • Haider Z
What I Capture During a PostgreSQL Sev‑1 So My RCA Isn’t Guesswork
Learn why PostgreSQL root cause analysis often fails after Sev-1 incidents, how evidence disappears, and how DBAs should approach incident RCA…
 • Haider Z
I Can’t Close 2025 Without Saying Thank You to the People Behind Postgres
A personal reflection on PostgreSQL, open-source gratitude, and the engineers we forget to thank.
 • Haider Z
PostgreSQL JSON vs JSONB: Missing GIN Index Detection in Sev-1
Discover the real difference between PostgreSQL JSON and JSONB. Learn how indexing, TOAST, and write amplification impact performance and run free SQL…
 • Haider Z
The PostgreSQL Trinity: The 3 Timeout Parameters 90% of Engineers Miss
Most teams only set statement_timeout. In this guide, you'll learn why lock_timeout and idle_in_transaction_session_timeout matter how to prevent hung…
 • Haider Z
PostgreSQL Tip: How to Use JSONB (Without Treating It Like MongoDB)
Most engineers misuse JSONB here’s how to avoid the trap.
 • Haider Z
60‑Second PostgreSQL Tip #2: How to Fix Lock Contention & Wait Events
Stop slow PostgreSQL queries in 60 seconds. Learn how to detect blocked queries, fix lock contention, and monitor wait events for high-concurrency…
 • Haider Z
© 2026 Haider Z · Privacy ∙ Terms ∙ Collection notice
Start your SubstackGet the app
Substack is the home for great culture