B-Tree Index Access Paths: Tuning Today and Tomorrow
This talk introduces the key access paths for B-tree indexes in PostgreSQL. Based on over ten years of experience with Oracle’s index skip scan, I will highlight common problems it can cause and show practical ways to avoid them in PostgreSQL. I will briefly demo DB Booster, a tool that automatically finds missing indexes, and discuss the future of index tuning in relational databases—self-tuning engines and PostgreSQL’s place in that shift.
Whatever will fit in 45 minutes:
-Index tuning introduction - fast, effective, impactful -Table without any index -B-Tree: the basic index -Why does the B-Tree index work -Index Seek -Index Scan -Index Skip Scan -Real-life issues with the Skip Scan in Oracle -How to avoid these issues in PotsgreSQL -Automated indexing - DB Booster -The future of the databases - self-tuning engines