Multidimensional search strategies for composite B-Tree indexes
Presenters Peter Geoghegan Source PGConf.dev 2025 Supercharging PostgreSQL: Mastering Complex OR Queries for Lightning-Fast Performance 🚀 Have you ever felt like your PostgreSQL queries were hitting a performance wall, especially when dealing with multiple OR conditions across indexed columns? You’re not alone! This presentation segment dives deep into the fascinating evolution of PostgreSQL’s query optimizer, revealing how it’s tackling this challenge head-on. 💡 The Problem: The Bitmap OR Bottleneck 😩 Traditionally, queries with complex OR conditions often defaulted to a “bitmap OR” approach. While functional, this method comes with a significant cost: ...