PGCon2018 - 2.5

PGCon 2018
The PostgreSQL Conference

Bruce Momjian
Day Talks - Day 1: Thursday - 2018-05-31
Room DMS 1160
Start time 11:15
Duration 00:45
ID 1228
Event type Lecture
Track Performance
Language used for presentation English

Flexible Indexing with Postgres

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.