Event language
UI language
<p>In this talk, we will explore the significant improvements to PostgreSQL's indexing system between versions 13 and 18. The community has focused on three key areas: making indexes faster, reducing their storage overhead, and minimizing maintenance costs. These improvements might seem incremental when viewed individually, but together they create substantial performance gains for production workloads.</p><p>BTREE indexes now handle common query patterns more efficiently. BRIN indexes have become more versatile. The query planner has become smarter about using indexes. These planner improvements provide performance benefits without requiring any schema changes. Beyond performance, PostgreSQL now tracks more detailed statistics about index usage patterns. This helps database administrators make better decisions about which indexes to keep and which to remove.</p><p>This session will demonstrate these improvements using real-world examples and discuss upcoming indexing features planned for version 19 and beyond.</p>
