Writing fast C code for a modern CPU (and applying it to PostgreSQL)
Presenters David Rowley Source PGConf.dev 2025 Supercharging PostgreSQL: A Deep Dive into Memory Access Patterns 🚀 PostgreSQL is a powerhouse database, but even the best systems can benefit from optimization. This presentation segment peeled back the layers, revealing how subtle changes in memory access patterns can lead to massive performance gains. Forget just optimizing individual queries - we’re talking about fundamentally changing how PostgreSQL interacts with your CPU! 🧠 The Core Message: It’s All About the Prefetcher! 🎯 ...