The Sev-1 Database
Subscribe
Sign in
Home
Notes
Real RCAs
PostgreSQL Insights
Database Engineering
Sev 1 Premium
DBA Toolkit
About
PostgreSQL Insights
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
[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
[Free] Understand PostgreSQL EXPLAIN ANALYZE Plan
Most engineers run EXPLAIN ANALYZE. Lets learn how to read what it means.
Mar 24
•
Haider Z @ Microsoft
3
Ask Me Anything – The Sev 1 Database Newsletter
Opening this space for you to ask me questions
Mar 20
•
Haider Z @ Microsoft
2
[FREE] PostgreSQL WAL Setting Nobody Changes Until It Causes Data Loss
Most engineers set wal_level = replica and never touch it again. Here’s what the documentation actually says and why it matters.
Mar 13
•
Haider Z @ Microsoft
[FREE] PostgreSQL Migration You Need to Read Before Moving to the Cloud
What nobody tells you about moving your PostgreSQL database off-prem and the one setting that turned a disaster into a success.
Mar 6
•
Haider Z @ Microsoft
[Real Story] How a PostgreSQL Benchmark Exposed a Critical SSH Security Backdoor
Lessons from a near-catastrophic open-source supply-chain attack that could have compromised Linux servers worldwide
Feb 23
•
Haider Z @ Microsoft
2
[FREE] Your Next Major Upgrade Doesn't Have to Be a Sev-1
What the PostgreSQL manual actually says about version upgrades (why most DBAs learn it the hard way)
Feb 20
•
Haider Z @ Microsoft
[FREE] Why Query Performance Degrades and Causes High CPU
Stale Statistics, Reset Stats, and Missing ANALYZE: The Hidden Causes Behind Query Plan Regressions
Feb 13
•
Haider Z @ Microsoft
[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.
Feb 6
•
Haider Z @ Microsoft
2
How Partition Key UPDATE Cause Serialization Failures
Why PostgreSQL triggers SQLSTATE 40001 during row movement and the architectural patterns to prevent it.
Jan 28
•
Haider Z @ Microsoft
2
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.
Jan 7
•
Haider Z @ Microsoft
6
2
This site requires JavaScript to run correctly. Please
turn on JavaScript
or unblock scripts
