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
What Is Infrastructure as Code? Benefits, Tools & Best Practices
Learn what is infrastructure as code and why use it. Discover key benefits, essential tools, and best practices to automate and secure your cloud infrastructure.
How to Negotiate a Software Developer Salary Offer
Master how to negotiate a software developer salary offer with data-driven tactics, psychological strategies, and legal tips. Maximize your total compensation today.
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.
MongoDB vs PostgreSQL When to Use Each: Key Differences
MongoDB vs PostgreSQL when to use each: compare ACID compliance, scalability, schema flexibility, and query power. Choose the right database for your project.
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.
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.
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.
Fine Tuning vs Retrieval Augmented Generation: A Guide
Compare fine tuning vs retrieval augmented generation for LLMs. Learn which approach suits your AI project based on accuracy, cost, and data freshness.
Nvidia capitalization $5.4 trillion: surpassed Europe
Nvidia reached $5.4 trillion capitalization, outpacing the 10 largest companies in Europe. Analysis of growth reasons, overheating risks, and forecasts for the AI chip market. Read the review.
How to Design RESTful APIs for Web Applications: Best Practices
Learn how to design RESTful APIs for web applications with best practices on URIs, HTTP methods, versioning, and documentation. Build scalable, intuitive APIs that developers love.