Hardianto logo Hardianto
Home About Service Stack Project Certificate Blog Contact
  1. Tags
  2. DevOps
PostgreSQL Performance Tuning at Scale: Indexing Strategies, Buffer Cache, and Connection Pooling

PostgreSQL Performance Tuning at Scale: Indexing Strategies, Buffer Cache, and Connection Pooling

An architectural deep dive into PostgreSQL internals: interpreting EXPLAIN (ANALYZE, BUFFERS), B-Tree vs BRIN indexing mechanics, WAL write path optimization, autovacuum worker tuning, and PgBouncer transaction-mode connection pooling.

Hardianto
H
Hardianto
August 20, 2026
6 min read
PostgreSQLDatabasesPerformance +3
Production Kubernetes Hardening: Kernel Observability and Networking with eBPF & Cilium

Production Kubernetes Hardening: Kernel Observability and Networking with eBPF & Cilium

Modern Kubernetes cluster engineering: bypassing legacy iptables with eBPF socket-layer routing, Cilium service mesh without sidecars, kernel-level L7 security policies, and zero-downtime Pod Disruption Budgets (PDB).

Hardianto
H
Hardianto
August 5, 2026
6 min read
KuberneteseBPFDevOps +4
Zero-Downtime Database Migrations: The Expand-and-Contract Pattern in High-Volume Production

Zero-Downtime Database Migrations: The Expand-and-Contract Pattern in High-Volume Production

Safely evolving relational database schemas without maintenance windows or lock contention: the 5-phase Expand and Contract lifecycle, lock-free column additions, asynchronous batch backfills, and blue-green API deployment backward compatibility.

Hardianto
H
Hardianto
April 10, 2026
5 min read
Database EngineeringDevOpsContinuous Delivery +2
© 2026 All rights reserved.

Made with ๐Ÿค by Hardianto !

Tanya AI Hardianto
Asisten AI Hardianto AI
Online ยท Siap Membantu
Halo! Saya Asisten AI Hardianto. Tanyakan apa saja tentang proyek, keahlian teknologi, pengalaman profesional, atau cara berkolaborasi dengan Hardianto!
Just now
Pertanyaan cepat:
Powered by Gemini & Portfolio AI Esc to close