Conference Schedule - PGConf.EU 2022

Directing PostgreSQL to Performance: PostgreSQL Index improvements over time

Date: 2022-10-26
Time: 17:20–18:10
Room: Berlin 1
Level: Intermediate

Starting with PostgreSQL 11, there have been multiple advances in the BTree index method - the default index method for PostgreSQL. However, this is not unique to BTree: most index methods have seen significant performance improvements, which have resulted in significant storage savings and improved performance over the past 5 major releases.

This talk will show notable improvements in PostgreSQL's included index methods since PG11, including deduplication and optimistic pruning of dead index tuples. After that, it will go through the improvements currently being worked on for PostgreSQL 16, and finally, it will discuss what the future might bring for the index methods included in PostgreSQL.

Speaker

Matthias van de Meent