Architecture
PostgreSQL 17: optimisations that change real queries
The PostgreSQL 17 optimisations that change real query plans sit in the planner and executor, so existing SQL benefits untouched. SAOP scans fold an IN list into a single index pass, worth 30 to 50 percent off p99 latency for 20 to 100 IDs. Streaming I/O cuts cold sequential scans and ANALYZE by 15 to 40 percent.