https://sudonull.com/postgresql-recovery-without-2-5-tb-backup
Real case of PostgreSQL cluster destruction from WAL deletion and SIGKILL. Recovery steps with ignore_system_indexes, crash_info and pg_dump patches. Lessons for 1C DBA.
Search Articles — Sudonull
Search Results
In this project
https://sudonull.com/clickhouse-why-columnar-dbms-accelerate-analytics-by-100-times
We explain using real benchmarks and a betting scheme: ClickHouse vs PostgreSQL and MySQL. Architecture, query examples, use cases. Read 5 minutes.
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.
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.
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.
Trending Now
How Does Retrieval Augmented Generation Work? RAG Guide
Learn how does retrieval augmented generation work: RAG reduces AI hallucinations, grounds responses in real data, and transforms LLMs into trustworthy systems. Start now.
How to Monitor Kubernetes with Grafana and Prometheus
Learn how to monitor Kubernetes with Grafana and Prometheus using the kube-prometheus-stack. Step-by-step guide to deploy, connect, and visualize cluster metrics.
Semiconductor Industry History & How It Works
Explore the history of the semiconductor industry and how does it work. Learn chip design, fabrication, and the global impact of this vital technology. Discover more.
What Is React Used For? UI Development Guide
What is React used for? Learn how this JavaScript library builds fast, scalable UIs with components and Virtual DOM. Discover its real-world uses and benefits.
Kubernetes Architecture Explained with Examples | Guide
Kubernetes architecture explained with examples: understand control plane, worker nodes, Pods, and deployment flow. Learn how clusters work with practical use cases.
How to Choose a Database for Your System: Expert Guide
Learn how to choose a database for your system with this evidence-based framework. Compare SQL, NoSQL, graph, and time-series databases to make the right decision.
Starlink Launch in Japan: Direct Smartphone Communication via Satellite
SpaceX and KDDI launched satellite communication for smartphones in Japan. Learn how Starlink Direct-to-Cell works, who can access it, and what hidden geopolitical goals this project pursues.
What Is MLOps and Why Is It Important? Key Concepts
Learn what is MLOps and why it is important for AI success. Discover key concepts, benefits, and how it bridges data science and operations for scalable ML.
How to Implement JWT Authentication: Step-by-Step Guide
Learn how to implement JWT authentication securely in your web API. This complete guide covers token issuance, validation, best practices, and production security.
How Netflix Scales Its Streaming Infrastructure: Cloud & CDN
Learn how Netflix scales its streaming infrastructure with AWS, Open Connect CDN, and chaos engineering. Discover the tech behind 270M subscribers and sub-100ms latency.