Tag: #operations
Writing on GPUs, LLMs, MLOps, Kubernetes — and mindset · 7 posts
The Complete Guide to Connection Pools: The Contract a Pooling Mode Makes with Your Application
A look at connection pools through the lens of a contract, based on PostgreSQL 18 and PgBouncer. Covers what the three pooling modes, session, transaction, and statement, each guarantee and each give up; why prepared sta
2026-08-15 · 16 min read #database#postgresql#pgbouncer#connection-pool#operationsThe Complete Guide to Database Performance Tuning: Measure Before You Touch a Parameter
Organizes PostgreSQL 18 performance tuning as a diagnostic order rather than a parameter list: profile the workload with pgstatstatements, split the bottleneck by wait event, read the cache and I/O metrics, and only then
2026-08-15 · 17 min read #database#postgresql#performance-tuning#monitoring#operationsThe Complete Guide to PostgreSQL Indexes: The Index Lifecycle from Design to Retirement
This piece treats the PostgreSQL 18 index as an operational asset with a full lifecycle: the design decisions behind column order, the judgment call between six index types, the procedure for building one safely with CON
2026-08-15 · 23 min read #database#postgresql#index#performance-tuning#operationsThe Complete Guide to Bulk Data Processing: COPY, Chunked Batches, and Reversible Operations
This guide covers how to safely load, update, and delete hundreds of millions of rows in PostgreSQL 18: COPY's options and defaults, the initial-load procedure the documentation recommends, tolerating bad rows with ONERR
2026-08-15 · 24 min read #database#postgresql#batch-processing#data-loading#operationsThe Air-Gapped Operations Playbook — Keeping Up with Security Patches, Rolling Back, and Managing CVE Lag
The story that begins after the transfer procedure is finished — the operations chapter, about running an air-gapped network for years. It first makes clear that slow CVE response inside an air-gapped network is not team
2026-08-14 · 13 min read #linux#rhel#air-gap#dnf#securityMigration Incident Case Studies and Checklists — Learning from Others Failures
Migrations are among the most common and most painful sources of outages. This article walks through typical failure modes like lock storms, replication lag, data loss, and irreversible changes, derives causes and lesson
2026-06-16 · 14 min read #database#migration#postmortem#incident#reliabilityKubernetes Advanced Operations Guide 2025: Autoscaling, Scheduling, Resource Management, Multi-Cluster
Everything about K8s advanced operations! Autoscaling (HPA/VPA/KEDA/Karpenter), Scheduling (Affinity/Taint-Toleration/Priority/Topology), Resource Management (QoS/LimitRange/ResourceQuota), Multi-Cluster (Cluster API/Fle
2026-04-14 · 15 min read #kubernetes#hpa#vpa#keda#scheduler