New query execution features in Postgres 10, 11 & PostgresPro
summary
Covers new query execution features in PostgreSQL 10 and 11 and in PostgresPro: parallel query execution improvements introduced in PostgreSQL 10, multi-column statistics added in 10, and planned JIT compilation of queries in PostgreSQL 11; also mentions that the company (PostgresPro) is adopting these enhancements.
AI-written summary · about
chapters (19)
- 0:00Introduction
- 1:31JIT query compilation
- 7:10Partitioning improvements
- 15:05Index changes
- 18:34Covering indexes
- 21:50Faster transactions
- 23:15WAL segment handling
- 24:43Parallel index builds
- 25:26Parallel queries
- 29:02Statistics improvements
- 30:26Window functions
- 31:07Full-text search
- 32:55Transaction management
- 33:16Domain handling
- 34:18Grouping optimization
- 37:10Self-join optimization
- 39:18Session parameter control
- 40:43Index statistics collection
- 41:25Q&A
