Engineering Publications
Technical Insights & Architecture Papers
Deep-dives on high-throughput backend architecture, Python & Django performance, real-time Voice AI, and resilient database modeling.
PostgreSQL Query Planner Internals: Calibrating Cost Factors, Work Memory, and SSD Random Page Penalties
Default PostgreSQL configuration parameters were calibrated decades ago for spinning magnetic hard disks. Learn how the cost-based optimizer calculates query plans and how to tune random_page_cost and work_mem for modern NVMe SSD storage.