PostgreSQL: Transactions, Locks, Isolation Levels, MVCC, VACUUM https://sudonull.com/postgresql-transactions-locks-isolation-levels-mvcc-vacuum
Deep dive into PostgreSQL transaction and locking mechanisms. Analysis of isolation levels (Read Committed, Repeatable Read, Serializable), MVCC, VACUUM, and methods for solving concurrency issues.
PostgreSQL: Query Optimization and Understanding Index Operations https://sudonull.com/postgresql-query-optimization-and-understanding-index-operations
Figure out why PostgreSQL ignores indexes. Detailed analysis of EXPLAIN ANALYZE, selectivity, correlation, and advanced index types to improve database performance.
Health Score for PostgreSQL: health monitoring https://sudonull.com/health-score-for-postgresql-health-monitoring
Learn how Health Score combines 150 PostgreSQL metrics into one indicator. Formulas, SQL queries, category weights and auto-diagnostics for DBA. Implement in your infrastructure.
PG_EXPECTO Prompt vs GENTLEMAN: PostgreSQL Analysis https://sudonull.com/pg-expecto-prompt-vs-gentleman-postgresql-analysis
Comparison of detailed PG_EXPECTO prompt and universal GENTLEMAN v10.2 for PostgreSQL load reports. Test results on DeepSeek, key metrics SPEED and iowait. Learn why detail wins. For DBA.
PostgreSQL Tuning: AI vs Load Tests https://sudonull.com/postgresql-tuning-ai-vs-load-tests
Comparison of AI Recommendations and Real PostgreSQL Benchmarks. Learn how OLTP and OLAP configs affect performance and why tests are more important than theory.