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/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.
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.
https://sudonull.com/postgresus-2-0-postgresql-backup-updates
Postgresus 2.0: AES-256 encryption, RBAC, zstd compression, Helm for k8s. Automate PostgreSQL backups for teams. Learn new features for DBA and DevOps.
https://sudonull.com/bufferpin-conflicts-in-postgresql-how-to-find-and-fix
Breaking down hidden BufferPin conflicts in PostgreSQL that affect replicas and autovacuum. Diagnostic, monitoring, and optimization methods for DBAs and developers.
Trending Now
How to Build an AI Agent with LangChain: Step-by-Step Guide
Learn how to build an AI agent with LangChain in this step-by-step tutorial. Set up tools, integrate LLMs, and create autonomous agents with memory.
How to Learn Python for Beginners: Step-by-Step Roadmap
Discover how to learn Python for beginners with this step-by-step roadmap. Master fundamentals, data structures, and build real projects. Start your coding journey today.
What Are Data Structures and Why They Matter | Basics
Learn what are data structures and why they are important for efficient software. Discover types, real-world impact, and how they shape modern computing.
What Is Kubernetes and How It Works: Complete Guide
Learn what is Kubernetes and how it works. Understand its architecture, self-healing, scaling benefits, and real-world impact. Start mastering container orchestration today.
JavaScript vs Python Which Is Better: Full 2026 Guide
JavaScript vs Python which is better for you? Compare ease of learning, salaries, use cases, and career paths to choose the right first language in 2026. Start now.
How to Write a SQL Query: Tutorial with Examples
Learn how to write a SQL query with practical examples. Master SELECT, WHERE, JOIN, GROUP BY, and best practices for readable, efficient SQL. Start now.
Google Gemini Ultra 2.0: record performance and price
Google introduced Gemini Ultra 2.0 with a context of up to 10 million tokens, surpassing GPT-5. Learn about the breakthrough architecture, price of $0.0005, and impact on the AI market. Read the full analysis.
React vs Vue Which Framework to Choose in 2025 | Comparison
React vs Vue which framework to choose in 2025? Compare performance, learning curves, job markets, and costs. Make a data-driven decision for your next project.
what is the difference between vpn and proxy: Key Privacy Tips
Learn what is the difference between vpn and proxy, from encryption to scope. Discover which tool fits your privacy needs with our expert comparison.
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.