Be Inclusive: Welcome Non-Key Columns in B-Tree Indexes — Markus Winand
Channel: PostgreSQL Europe
Date: 2019-12-23

PostgreSQL 11 introduced the INCLUDE clause for b-tree indexes. The main intention of this clause is to enable Index Only Scans without including selected columns into the index key. But the INCLUDE clause has many other interesting capabilities that might be even more useful than the support of Index Only Scans.

This talk gives you a brief introduction into b-tree indexes, Index Only Scans and what the INCLUDE clause does. It demonstrates where cases the INCLUDE clause can be beneficial and discusses a few more subtle benefits that are not commonly known. Finally, the talk also shows the limits of the INCLUDE clause in PostgreSQL 11.


https://www.postgresql.eu/events/pgdayparis2019/schedule/session/2361-be-inclusive-welcome-non-key-columns-in-b-tree-indexes/