Conference Schedule - PGConf NYC 2021

Flexible Indexing with Postgres

Date: 2021-12-03
Time: 10:50 - 11:40
Room: Salon C
Level: Intermediate
Feedback: Leave feedback

When considering database indexing, many people are confused by the many Postgres indexing structures available, and the many data-type-specific index lookup methods. For example, brin allows for efficient indexing of many columns. gin indexing specializes in the rapid lookup of keys with many duplicates — an area where traditional btree indexes perform poorly. This is particularly useful for json and full text searching. GiST allows for efficient indexing of two-dimensional values and range types. This talk explores the various indexing features of Postgres and when to use them. This is ideal when presented after my Non-Relational Postgres presentation.


The following slides have been made available for this session:


Bruce Momjian