Tag: #performance
Writing on GPUs, LLMs, MLOps, Kubernetes — and mindset · 72 posts
PostgreSQL VACUUM, MVCC, and Bloat Optimization Guide
A comprehensive guide to PostgreSQL VACUUM, MVCC internals, and table bloat optimization for maintaining database performance.
2026-03-12 · 19 min read #database#postgresql#vacuum#mvcc#autovacuumMySQL Query Optimization Practical Guide: From EXPLAIN Analysis to Index Design and Slow Query Tuning
A comprehensive guide covering MySQL EXPLAIN/EXPLAIN ANALYZE output interpretation, B-Tree/Hash/Full-text index types, composite index design (leftmost prefix rule, covering index), query rewriting patterns (subquery to
2026-03-11 · 17 min read #database#mysql#query-optimization#explain#index-tuningPostgreSQL Advanced Indexing Guide: GIN, GiST, BRIN, and Partial Index in Practice
A deep dive into PostgreSQL advanced index types. Beyond B-tree, we explore GIN (inverted index), GiST (spatial index), BRIN (block range index), Partial/Expression Index internals, real-world use cases, EXPLAIN ANALYZE-
2026-03-10 · 16 min read #database#postgresql#indexing#gin-index#performanceComplete Guide to Network Performance Analysis: Measurement, Diagnosis, and Monitoring
A comprehensive guide covering network performance metrics, bandwidth testing with iperf3/mtr/netperf, TCP window analysis, MTU troubleshooting, and Prometheus/Grafana monitoring for practical network diagnostics.
2026-03-08 · 15 min read #networking#performance#monitoring#troubleshootingLinux Kernel Parameter Tuning Guide: sysctl + Boot Params, Safe Changes and Rollback
This guide covers Linux kernel tuning strategies using sysctl runtime parameters and boot parameters. It provides recommended values for networking, memory, filesystem, and security categories, along with pre-change back
2026-03-07 · 11 min read #linux#kernel#sysctl#performance#tuningPostgreSQL Partitioning Production Guide: Range, List, and Hash Strategies for Billion-Row Tables
A comprehensive guide to PostgreSQL table partitioning covering range, list, and hash strategies, partition pruning optimization, pgpartman automation, zero-downtime migration from monolithic tables, and production maint
2026-03-07 · 17 min read #database#postgresql#partitioning#performance#billion-row-tablesPostgreSQL Partitioning Complete Guide: Range, List, Hash Strategies and Performance Optimization
Learn how to dramatically improve the performance of large tables using PostgreSQL declarative partitioning. Covers Range, List, and Hash partitioning strategies along with partition pruning and automated management.
2026-03-03 · 21 min read #database#postgresql#partitioning#performance#query-optimizationN+1 Problem Deep Dive — The Silent Performance Killer in ORMs
What the N+1 problem is, why it is dangerous, how to find it, and how to fix it. A complete guide with practical code covering solutions across all ORMs including Django, SQLAlchemy, JPA/Hibernate, Prisma, and ActiveReco
2026-03-02 · 10 min read #database#n-plus-1#orm#django#sqlalchemySQL Practical Cheatsheet — Complete Reference for Everyday Commands
From SELECT, UPDATE, INSERT, DELETE to subqueries, window functions, CTEs, index strategies, and execution plan analysis. All the SQL patterns you use daily in one place. Copy and use right away.
2026-03-02 · 36 min read #database#sql#mysql#postgresql#selectPostgreSQL Performance Tuning Practical Guide — Query Optimization, Index Strategy, EXPLAIN Analysis
A hands-on guide to the core of PostgreSQL performance tuning. Covers how to read EXPLAIN output, index strategies, query optimization patterns, and configuration tuning with practical code examples you can apply immedia
2026-03-02 · 11 min read #database#postgresql#performance#sql#indexingThe New Throne Beyond vLLM: 5 Reasons SGLang Is Changing the LLM Inference Landscape
From SGLang's RadixAttention-based KV cache management and 29% throughput advantage through hyper-specialized design, to its 4,000-line Python zero-overhead scheduler, Prefill-Decode Disaggregation, and Compressed FSM-ba
2026-03-01 · 35 min read #sglang#llm-inference#vllm#radix-attention#model-servingNginx Configuration Complete Guide: 15 Essential Topics from Architecture to Production Optimization
From Nginx event-driven architecture and configuration structure to reverse proxy, load balancing, SSL/TLS, caching, rate limiting, security headers, performance tuning, and health checks -- a comprehensive guide to 15 e
2026-03-01 · 33 min read #nginx#reverse-proxy#load-balancing#ssl#tls