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.
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.
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.
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.
Master how to negotiate a software developer salary offer with data-driven tactics, psychological strategies, and legal tips. Maximize your total compensation today.
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: compare ACID compliance, scalability, schema flexibility, and query power. Choose the right database for your project.
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.
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.
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.
Compare fine tuning vs retrieval augmented generation for LLMs. Learn which approach suits your AI project based on accuracy, cost, and data freshness.
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.
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.