Schedule - PGConf.EU 2019
nbtree-indexes in PostgreSQL. Useful novelties.
Date: 2019-10-16
Time: 14:40–15:30
Room: Parini
Level: Intermediate
nbtree-indexes exists in PostgreSQL for decades, this is the default and the most commonly used index type. In the upcoming 12th version there will be significant changes to the way these indexes work. We'll start with a small insight into the way nbtree indexes work in general: internal structures, basic operations, as well as problematic areas that exists and show up from time to time (yes, we're speaking about bloat). Next, we'll see what had been done for the 12th version of PostgreSQL (expected to be released during the fall) and also what are the possibilities for future improvements. Finally, some words on how to use indexes, how to "disable" index, and also on how to use multicolumn indexes.
Slides
The following slides have been made available for this session: